Problems with utf-8 encoding in php

Posted by Addsy on Stack Overflow See other posts from Stack Overflow or by Addsy
Published on 2010-05-21T15:42:10Z Indexed on 2010/05/21 16:10 UTC
Read the original article Hit count: 350

Filed under:
|
|

Hi,

Another utf-8 related problem I believe...

I am using php to update data in a mysql db then display that data elsewhere in the site. Previously I have run into utf-8 problems before where special characters are displayed as question marks when viewed in a browser but this one seems slightly different.

I have a number of records to enter that contain the è character. If I enter this directly in the db then it appears correctly on the page so I take this to mean that utf-8 content is being output correctly.

However when I try and update the values in the db through php, then the è character is replaced. What appears instead is & Atilde ; & uml ; (without the spaces) which appears in the browser as è

I have the tables in the database set to use UTF-8. I believe this is correct cos, as mentioned, if I update the db through phpMyAdmin, its all ok. Similarly I have set the character encoding for the page which seems to be correct. I am also running the sql statement "SET NAMES 'utf8';" before trying to update the db.

Anyone have any other ideas as to where the problem may lie?

Many thanks

© Stack Overflow or respective owner

Related posts about utf-8

Related posts about php