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]

Reply via email to