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