I have a MySQL database that is storing business data... In the database, when running a select against a business name that contains an accented e (é), it comes up correctly (showing me that it is stored correctly.) On our website, though, it is showing up as the diamond with the question mark.
I checked out database and found the following:
Character_sets_dir /usr/share/mysql/charsets/ Character_set_client utf8 Character_set_connection utf8 Character_set_database latin1 Character_set_filesystem binary Character_set_results utf8 Character_set_server latin1 Character_set_system utf8
Where things get lost is on the website itself... The web page is encoded as UTF8...
Any ideas of where the conversion may be failing?