Re: mysqldump corrupting utf8 data

2006-08-01 Thread Ravi Prasad LR
How are you importing the dump into mysql? Importing by piping the dump file to mysql may broke some chars due to shell. Have you tried this: (with in mysql client) SET NAMES UTF8; SET CHARACTER SET UTF8 source /pathto/dump.sql Cheers, --Ravi Sean O'Hara wrote: Hi All, I've been googling al

mysqldump corrupting utf8 data

2006-08-01 Thread Sean O'Hara
Hi All, I've been googling all morning trying to find info on how to do a mysqldump of a utf8 encoded database from which I can restore without corrupting all the non ascii characters. If anyone has any pointers on this, I'd be most grateful. Here is my setup. I am building a ruby on rail