# Tamil unicode support rails with mysql

**URL:** <https://www.ruby-forum.com/t/tamil-unicode-support-rails-with-mysql/187899>\
**Category:** Rails\
**Created:** [May 1, 2010, 9:47am UTC](https://www.ruby-forum.com/t/tamil-unicode-support-rails-with-mysql/187899 "2010-05-01T09:47:07Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![nirosh](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/n/ce7236/32.png) [@nirosh](https://www.ruby-forum.com/u/nirosh)\
**Post date:** [May 1, 2010, 9:47am UTC](https://www.ruby-forum.com/t/tamil-unicode-support-rails-with-mysql/187899/1 "2010-05-01T09:47:07Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![nirosh](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/n/ce7236/32.png) [@nirosh](https://www.ruby-forum.com/u/nirosh)\
**Post date:** [May 1, 2010, 10:03am UTC](https://www.ruby-forum.com/t/tamil-unicode-support-rails-with-mysql/187899/2 "2010-05-01T10:03:31Z")

</div>

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

On 1 May 2010 08:45, nirosh [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> 

## –

Nandri(Thanks in Tamil),  
Amala S.