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.kand...@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-t...@googlegroups.com. > To unsubscribe from this group, send email to > rubyonrails-talk+unsubscr...@googlegroups.com<rubyonrails-talk%2bunsubscr...@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-t...@googlegroups.com. To unsubscribe from this group, send email to rubyonrails-talk+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.