Re: [newbie question] how do you change the default charset of MySQLunder windows

2002-10-30 Thread Daniel Kiss
Hi Paul, Was the table01 created before you did the new settings and restart the service? Because if yes, youhave to recreate the table or rebuild the indexes. Anyway, I don't really know how chinese double-byte character representation works. Fortunately the Hungarian language uses the latin c

Re: [newbie question] how do you change the default charset of MySQLunder windows

2002-10-29 Thread Daniel Kiss
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_p

Re: [newbie question] how do you change the default charset of MySQLunder windows

2002-10-29 Thread Daniel Kiss
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,