Missing/Unknown Character (accents & utf8)
Posted by: Robert Wallsworth
Date: March 08, 2010 11:02PM

Wow, this is seriously frustrating.

I've been messing around in an attempt to correctly output accented characters and I've had no luck so far. It looks like everything is set to UTF8 -> utf8_unicode_ci yet the accented character comes out as an unknown character or something like it (depending on the content-type, it'll not show, show an unknown character or just something along those lines) Pages are currently outputted as UTF-8.

Am I doing something wrong or missing something?

Here are a couple details:

character set client utf8
character set connection utf8
character set database utf8
character set filesystem binary
character set results utf8
character set server utf8
character set system utf8

collation connection utf8_unicode_ci
collation database utf8_unicode_ci
collation server utf8_unicode_ci

Database -> Collation: utf8_unicode_ci
Table -> Collation: utf8_unicode_ci
Fields -> Collation: utf8_unicode_ci

In phpMyAdmin I see the records with the accents without any problems but whenever I output them to PHP, things go nuts.

Edit: Also, if I'm not mistaken my framework does SET NAME (...) before the queries.

Thanks in advance,
R



Edited 1 time(s). Last edit at 03/08/2010 11:04PM by Robert Wallsworth.

Options: ReplyQuote


Subject
Views
Written By
Posted
Missing/Unknown Character (accents & utf8)
5045
March 08, 2010 11:02PM


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.