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
