Was the table01 created before you did the new settings and restart the service?
Because if yes, youhave to recreate the table or rebuild the indexes.
Anyway, I don't really know how chinese double-byte character representation works. Fortunately the Hungarian language uses the latin characters. In spite of this I have problems with sorting Hungarian strings also. :-)
Good luck,
Daniel
At 16:13 2002.10.30. +0800, you wrote:
Hi Daniel, Actually I've tried the following in the "my.ini" file:[mysqld] default-character-set=big5 [WinMySQLAdmin] Server=C:/mysql/bin/mysqld-nt.exe but when I open up the command prompt and enters the mysql monitor, try the following I got into something like this: mysql> update table01 set field03 = "some chinese chars"; "> Note- 1) field03 is of type char(10); 2) the chinese character I've enter just happened to have one of its internal double-byte representation as a back-slash (doh!) Any suggestion on how to fix this? Thanks a lot! Paul
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php