Skip navigation links

MySQL Forums :: Character Sets, Collation, Unicode :: UTF-8 not displaying french characters ex:éàèç


Advanced Search

UTF-8 not displaying french characters ex:éàèç
Posted by: Sebastien Couture ()
Date: August 01, 2008 02:27AM

I've been trying to fix this for days.

Here is the site.
http://www.tousergo.com/lexique.php

The HTML encoding is set to UTF-8. I created a new database and tables with utf8_unicode_ci. I imported my data as UTF-8 in the import page and the file was UTF-8 encoded. However, the page still doens't display the characters properly.

Unfortunately I don't have access to ssh but When I look at the table in phpMyAdmin, the characters show up fine or if I change the page page encoding in my browser to ISO-8859-1.

I not too knowledgeable with encoding but to me, there is no mismatch anywhere, however the characters still seem to be encoded as ISO-8859-1.

However I just noticed this on the Databases page

Database Ascending Collation
information_schema utf8_general_ci
tousergo utf8_general_ci
tousergo:first utf8_unicode_ci
tousergo_2 utf8_unicode_ci
Total: 4 latin1_swedish_ci

The total line shows latin1_swedish_ci

Can anyone offer a possible solution.

Thank you
Sebastien



Edited 1 time(s). Last edit at 08/01/2008 02:30AM by Sebastien Couture.

Options: ReplyQuote


Subject Views Written By Posted
UTF-8 not displaying french characters ex:éàèç 8061 Sebastien Couture 08/01/2008 02:27AM
Re: UTF-8 not displaying french characters ex:éàèç 4130 Sergio González 08/18/2008 12:52PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.