Ruby on Rails Saturday, May 1, 2010

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

On 1 May 2010 08:45, nirosh <kunalan.kandiah@gmail.com> wrote:
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

--
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To post to this group, send email to rubyonrails-talk@googlegroups.com.
To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.




--
--
Nandri(Thanks in Tamil),
Amala Singh

--
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To post to this group, send email to rubyonrails-talk@googlegroups.com.
To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.

No comments:

Post a Comment