[TYPO3] Chinese language on a european website

[Oleg L. Sverdlov]

AFAIK mysql 4.0 does not support different charsets for databases.


this should be utf8 without  dash '-'.


ALTER DATABASE db DEFAULT CHARACTER SET utf8;

ALTER DATABASE db DEFAULT COLLATE utf8_general_ci;



Francois Suter wrote:

>> The only question is that the information for converting an existing
>> database to UTF-8 is sadly missing and I can't seem to find the
>> relevant instructions in the MySQL doc? Has anyone experience with  
>> this?
>>     
>
> Actually I found part of the answer just after posting this. I tried  
> the following command:
>
> ALTER DATABASE t3_db DEFAULT CHARACTER SET utf-8 COLLATE utf8_unicode_ci
>
> but it returned an SQL error. I'm running on MySQL 4.0.26. Doesn't  
> this version support the above statement? I tried without the  
> "DEFAULT" or the "COLLATE" part, but it didn't help.
>
> François Suter
> Directeur technique
> -----------------------------------------------------
> Cobweb Development Sàrl
> www.cobweb.ch
>   
-- 
*OLS Software* Websites and Software Development.
Tel./Fax 03-613-2865 , mobile: 054-424-0865
Email info at ols.co.il
URL http://www.ols.co.il