My programm connect to MYSQL server(4.1.12), set it's character set by
"set NAMES gbk", the variables when client programm started is
After a long while, like one night, I found the client character set have
been changed to latin,
it seems related to some "timeout" value, the wait_timeout and
interative_timeout is 28800(8 hours).
I tested same program with MySQL 4.1.7, the connection was disconnnected by
server since wait_timeout was set to 8 hours.
why the characoter set would be changed with MYSQL 4.1.12? My programm use
MYSQL C API.
MySQL setting : My.cnf
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).