Re: Unicode with MySQL4.1

[Jeremy March]

Remember that utf8 is not the same as the Unicode codepoints.  If you want 
to enter utf8 like that you need to convert it from ucs2 first.  Try this:

SELECT convert(_ucs2 0x00d4 using utf8);

and to insert:

INSERT INTO your_table values (convert(_ucs2 0x00d4 using utf8));

You can compare the character with its utf8 hexidecimal:

SELECT hex(my_column), my_column FROM your_table;

Hope this helps,
Jeremy March
_________________________________________________________________
MSN Shopping upgraded for the holidays!  Snappier product search... 
http://shopping.msn.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]