Hi,
Thank you very much for the reply.
> $dbh->do("SET character_set_results="ujis"');
This works! Is there any way I can set this value on MySQL config file,
so I don't need to change all my scripts?
Right now my my.cnf looks like:
[mysqld]
default-character-set=ujis
default-collation=ujis_japanese_ci
[client]
default-character-set=ujis
[mysql]
default-character-set=ujis
> > What do your 'show' statements return when you execute them from the
> > perl script?
character_set_client ujis
character_set_connection latin1
character_set_database ujis
character_set_results latin1
character_set_server ujis
character_set_system utf8
character_sets_dir /usr/share/mysql/charsets/
Why does character_set_connection set back to latin1? I already set the
ujis value in my.cnf, and if I connect using mysql client, this value is
correctly set to ujis.
How can I set character_set_connection so it defaults to ujis, no matter
where is the connection coming from?
--bk
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]