Hello, I have a strange problem on the charset on mysql. I'm using mysql-5.0.45, compiled from the source, and enabled: '--with-charset=utf8' '--with-extral-charsets=all' when compiling it.
My default charset in my.cnf is utf8: character-set-server=utf8 OK I logined into mysql and run: mysql> set names 'gbk'; ERROR 1115 (42000): Unknown character set: 'gbk' The error shows as above. These were the 'show' command's output: mysql> show variables like 'character%'; +--------------------------+----------------------------------------+ | Variable_name | Value | +--------------------------+----------------------------------------+ | character_set_client | utf8 | | character_set_connection | utf8 | | character_set_database | utf8 | | character_set_filesystem | binary | | character_set_results | utf8 | | character_set_server | utf8 | | character_set_system | utf8 | | character_sets_dir | /var/mysql5.0.45/share/mysql/charsets/ | +--------------------------+----------------------------------------+ 8 rows in set (0.00 sec) mysql> show charset like 'utf8'; +---------+---------------+-------------------+--------+ | Charset | Description | Default collation | Maxlen | +---------+---------------+-------------------+--------+ | utf8 | UTF-8 Unicode | utf8_general_ci | 3 | +---------+---------------+-------------------+--------+ 1 row in set (0.01 sec) mysql> show charset like 'gbk'; Empty set (0.00 sec) Since I have enabled --with-extral-charsets=all why can't I use gbk charset? How to resolve it? Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org