Hi Moli, I hope this is because there is spelling mistake. It should be * '--with-extra-charsets=all'*, but you have given '--with-*extral*-charsets=all'. That's why only the utf8 has been installed and not the other charsets.
Regards, Thiyaghu CK www.mafiree.com On Wed, Feb 3, 2010 at 2:26 PM, <m...@normalperson.e4ward.com> wrote: > 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=theyaho...@gmail.com > >