I have an application which uses Mysql 3.23 and a latin1 character set. In a near future I will have to deal with texts in french, italian, korean and japonese. I'm looking into UTF-8 for mysql.
I did not see anything which enable UTF-8 for mysql 3.23 or 4.0 : character set list does not include utf8.
The only work-around I've seen is to multiply by 4 the column size (one character can be up to 4 bytes in utf8) and store text as some binary data. I do not care about size constraints but as a UTF-8 text can be coded in more than one way, I expect comparisons, search and tests problems when dealing with utf8 texts. This is not really acceptable.
- Is there a way to enable the server (3.23 or 4.0) to use UTF8 ? i do not need the mysql 4.1 character set switching capabilities, staying always int UTF8 with no conversion is fine for me.
- If there is no way to make mysql 3.23 or 4.0 handle UTF8, do someone have a work-around other than mine ?
- If there is no work-around, can someone tell me a release date for mysql 4.1 as stable ? I know there is no fixed date, I only need some bet for an aproximation : 2 weeks, 2 month, 6 month, 1 year, 2 years ?
Thanks in advance for any help you could give me. -- Eric Daspet
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]