Hello,
I would like to know the status of the UTF8 support in MySQL 4.1.
I tried to create a table using utf8 charset, and inserting hebrew text into it. it seems like it still treats this text as binary - for example the length() function returns 8 on 4 chars string, or when cretting a column using varchar(4) i can only insert 2 letters to it.
LENGTH() returns the length in bytes. Try CHARACTER_LENGTH() instead.
A declaration of VARCHAR(n) means n bytes, not n characters. I believe this may change sometime, but I do not know when.
So few questions:
1. Do you plan to support utf8 at this level, with all the string functions working properly with utf8 (my first impression was that thats what "utf8 support" is..).
You do know that you're using an alpha release? This means that there is still work to be done, and that comments such as yours about problems that you find are valuable.
2. What about fulltext search on UTF8 strings?
Unavailable.
3. Is there any target date for releasing a stable version of 4.1?
4.1 is just at the very beginning of its development cycle.
Sagi
-- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
