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:

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 s

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

[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 --