It seems to be working, but I am facing a glitch with display. I tried select convert(_ucs2 0x0400 using utf8); +----------------------------------+ | convert(_ucs2 0x0400 using utf8) | +----------------------------------+ | ? | +----------------------------------+ 1 row in set (0.00 sec)
Why is '?' displayed instead of the actual character? Thanks, Srinivas --- Jeremy March <[EMAIL PROTECTED]> wrote: > 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] > ===== I am not afraid of losing. But I don't like it. __________________________________ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
