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.

nirosh

Nirosh,

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