tamil unicode support rails with mysql

i have a problem with mysql. i have developed an app witch is works on unicode based. everything worked so far.

now i migrate the db sqlite3 to mysql then my Unicode characters appear as ???.

any idea to solve this problem.



How do you migrate sqlite3 to mysql?

Please ensure that your migration is correct. When you export database into files you need to ensure that the file format is utf compatible. If it is ASCII compatible it wont work

Before you import the data into mysql, view the import script into a utf8 compatible editor and see that you tamil characters are visible.

Then make sure that mysql engine is utf8 enabled. Columns defined are utf8 compatible columns.

Cheers Amala Singh