Issues with MySql database encoding


#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 removed_email_address@domain.invalid 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?