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 ----- Original Message ----- From: "Daniel Kiss" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, October 30, 2002 3:50 PM Subject: Re: [newbie question] how do you change the default charset of MySQL under windows > Hi Paul, > > I does not matter if you use the my.ini in the Windows directory or the > my.cnf in the c: root, but the last one will be used first. > You my.cnf (and my.ini also) should look like this: > > ---stat of my.cnf > [mysqld] > default-character-set=hungarian > default-table-type=InnoDB > innodb_data_file_path = ibdata1:10M:autoextend:max:2000M > innodb_data_home_dir = c:\mysql\ibdata > innodb_log_group_home_dir = c:\mysql\ibdata\logs > innodb_log_arch_dir = c:\mysql\ibdata\logs > set-variable = innodb_mirrored_log_groups=1 > set-variable = innodb_log_files_in_group=3 > set-variable = innodb_log_file_size=8M > set-variable = innodb_log_buffer_size=1M > innodb_flush_log_at_trx_commit=1 > innodb_log_archive=0 > set-variable = innodb_buffer_pool_size=48M > set-variable = innodb_additional_mem_pool_size=2M > set-variable = innodb_file_io_threads=4 > set-variable = innodb_lock_wait_timeout=50 > ---end of my.cnf > > This is a simple my.cnf I use under WinNT for InnoDB tables as default > table type, and 'hungarian' as default character set. Basically you need > only the first two lines. But the point is, that the default-character-set > line must be in the [mysqld] section, because the mysql daemon (or service > under WinNT) will take only commands only in this section into consideration. > > Bye, > Daniel > > At 15:44 2002.10.30. +0800, you wrote: > >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 > > > --------------------------------------------------------------------- > 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