Issues with MySql database encoding

rubyonrails-talk
1

Hello, I am working on an international project that requires UTF-8 encoding for letter characters. I have successfully changed my local development machine to UTF-8 and all characters are holding as they should. However, my production server is a Solaris box, and it is not holding the proper characters even after I change the database encoding.

I would prefer not to use htmlentites as it can be quite messy and does not yield an accurate search result.

Does anyone have any suggestions?

2

database.yml is set properly (has been from the beginning):

production:   adapter: mysql   encoding: utf8

3

database.yml is set properly (has been from the beginning):

production: adapter: mysql encoding: utf8

Are the encodings for the various columns set properly?

Fred

4

How was the database created? Through MySQL SQL import? Does the sql have UTF-8?