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 seem to do the trick. Should I create a "my.cnf" in the C: root instead with the "default-character-set" to it? Thanks a lot! Paul ----- Original Message ----- From: "Daniel Kiss" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, October 30, 2002 3:06 PM Subject: Re: [newbie question] how do you change the default charset of MySQL under windows > Hi > > You have to write a line like this into your my.cnf (in the C: root directory): > > default-character-set=... > > or whatever you like. You can find examples in your mysql directory for the > my.cnf file. > Oh, yes! You're from Hong Kong. So maybe you need this: > > default-character-set=big5 > > Bye, > Daniel > > At 14:47 2002.10.30. +0800, you wrote: > >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 > > > > > >--------------------------------------------------------------------- > >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 > > --------------------------------------------------------------------- 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
