Issues with MySql database encoding

Rails
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

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

4

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