Re: default-character-set=gbk ,setBytes() cause SQL syntax error.

[Zhao Bin]

I'm very glad with you reply, MySQL version is 4.1.7 on windows.

As you indicated, I check MySQL VARIABLES as below:

mysql> SHOW VARIABLES LIKE '%character%';
+--------------------------+----------------------------------+
| Variable_name | Value |
+--------------------------+----------------------------------+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | gbk |
| character_set_results | latin1 |
| character_set_server | gbk |
| character_set_system | utf8 |
| character_sets_dir | C:\RiseNet\mysql\share\charsets/ |
+--------------------------+----------------------------------+
7 rows in set (0.04 sec)

Should I need change character_set_connection or other to GBK? How to do it ?

Thanks very much.
yours,
ZhaoBin