Re: [newbie question] how do you change the default charset of MySQL under windows

2002-10-30 Thread Paul Yuen
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

Re: [newbie question] how do you change the default charset of MySQL under windows

2002-10-30 Thread Paul Yuen
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

2002-10-29 Thread Paul Yuen
Hi all, I've checked the doco and found that it can be changed by ./configure under Linux, but how do I change the default charset of MySQL under Win2K. Do I have to re-compile the source or better yet can I change it on the fly or using WinMySQLAdmin or something? TIA Paul

Re: [newbie question] how do you change the default charset of MySQL under windows

2002-10-29 Thread Paul Yuen
Thanks Daniel, I've looked for the my.cnf file but couldn't find it but I found a my.ini under the c:\Winnt directory, with the following content: [WinMySQLAdmin] Server=c:/mysql/bin/mysqld-nt.exe I've tried appending the line default-character-set=big5 to it and restarted MySQL but doesn't