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 default-collation=ujis_ja

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 t

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 th

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