RE: [PHP] French character string encoding

Angelo Zanetti wrote: > Your � didn't display properly at all - I tried ISO-8859-1 and > UTF8. > > /Per Jessen, Zürich > > > Hi Per that’s the problem I am having, this is how data from a project > I inherited is saved in the DB and I cant get it to show. Hi Angelo what's the charset of your database table? Do e.g. "SHOW CREATE TABLE xxxxx" in mysql to see what the table is stored as. > However I get normal data eg: ème est très haute. To show if its saved > like that in the DB, I just do: > > echo utf8_encode("ème est très haute."); OK, all of that came through fine in ISO-8859-1 as quoted-printable. And yes, if you to put that in a UTF-8 page, utf8_encode() would be the right thing. > and it works well. Is there anyway you think I can get the data in the > DB to format correctly perhaps using some sort of string command? Find out what charset the database is stored in - if it's ISO-8859-1 or a close relative (which I suspect), you need to either serve your pages as ISO-8859-1 or convert to UTF-8 using e.g. utf8_encode() and serve the pages as UTF-8. Have you got a sample I can look at? (feel free to send me URLs off-line). /Per Jessen, Zürich