Hi, I am trying to insert unicode characters in to a table from mysql client, but I am unable to.
My configuration is MySQL4.1.0-alpha on SunOS8. Installed MySQL from source with support for all character sets. Created table with create table mm(xyz varchar(10) character set utf8), and started mysql client with "mysql --default-character-set=utf8". Then I tried to insert unicode characters in to mm using hexadecimal notation. But its not working. I read in the manual that hexadecimal constants are parsed pair by pair. Is that the case for Unicode character set also? If so, how can I insert unicode characters in to tables from command line. I tried following command. select 0x00D4; +--------+ | 0x00D4 | +--------+ | | +--------+ 1 row in set (0.00 sec). My machine's default character set US-ASCII. Is that creating problems with displaying unicode characters? I would appreciate your help. Thanks, Srinivas ===== I am not afraid of losing. But I don't like it. __________________________________ Do you Yahoo!? Exclusive Video Premiere - Britney Spears http://launch.yahoo.com/promos/britneyspears/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
