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
