Issues with MySql database encoding

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?

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

production:
adapter: mysql
encoding: utf8

On Jun 9, 5:48 pm, Mindtonic [email protected] wrote:

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

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