Re: Character set on 4.1 and ujis support

2005-06-26 Thread Batara Kesuma
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

Character set on 4.1 and ujis support

2005-06-24 Thread Batara Kesuma
Hi, I just moved my DB from 4.0 to 4.1.11. I used mysqldump to dump the data first, and then inserted it to the new DB. The character set of the data is EUC-JP (ujis). My problem is, I can see the character correctly if I connect to mysql server using mysql client. For example: # mysql -e

Re: Character set on 4.1 and ujis support

2005-06-24 Thread Gleb Paharenko
Hello. What do your 'show' statements return when you execute them from the perl script? Batara Kesuma [EMAIL PROTECTED] wrote: Hi, I just moved my DB from 4.0 to 4.1.11. I used mysqldump to dump the data first, and then inserted it to the new DB. The character set of the

Re: Character set on 4.1 and ujis support

2005-06-24 Thread mfatene
Hi, you may use somethinh lik ethis : $dbh-do(SET character_set_results=ujis'); look at http://dev.mysql.com/doc/mysql/en/charset-general.html Hope that helps Mathias Selon Gleb Paharenko [EMAIL PROTECTED]: Hello. What do your 'show' statements return when you execute them from the perl