Thanks Daniel, You've been extremely help already. Thanks a lot! I'll let you know if I finally manage to get it working.
Thank you once again! Paul ----- Original Message ----- From: "Daniel Kiss" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, October 30, 2002 4:17 PM Subject: Re: [newbie question] how do you change the default charset of MySQL under windows > Hi Paul, > > 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 > > --------------------------------------------------------------------- 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