Hi, I have installed XFree86 4.3 and started xterm with xterm -fn "-Misc-Fixed-Medium-R-SemiCondensed--13-120-75-75-C-60-ISO10646-1"
Then started mysql with mysql --default-character-set=utf8 Set LC_CTYPE to en_US.UTF-8 on my SuSE 8 machine. Still I am not able to display Unicode characters. I tried select convert(_ucs2 0x0400 using utf8); +----------------------------------+ | convert(_ucs2 0x213e using utf8) | +----------------------------------+ | ? | +----------------------------------+ 1 row in set (0.01 sec) This is working though, select convert(_ucs2 0x00D4 using utf8); +----------------------------------+ | convert(_ucs2 0x00D4 using utf8) | +----------------------------------+ | Ô | +----------------------------------+ 1 row in set (0.01 sec) I appreciate your help Thanks, Srinivas ===== Its what inside that makes the difference -- Lance Armstrong __________________________________ 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]