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
>
>

Reply via email to