Geek asks and answers

Problem with French UTF-8 Percussion Symbols

When I see the data stored in the mysql database using phpmyadmin, the characters are saved exactly as é à ç, however, when I use php to display this data in an html document that has the following structure:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title></title>
</head>

<body>
</body>
</html>

I got a square instead of an accented character, however I don't have this problem with any accented characters of static content that were not loaded from mysql on the same page.

when I see the source code of the page, they seem the same! eg:

the portion of static data in the source code that is displayed as:

éçà

part of mysql origin data:

éçà

I tried to replace

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

with

<meta http-equiv="Content-Type" content="text/html; charset=windows-1552" />

and as a result, I got mysql one fixed, static with squares!

any clues?

+5
2

, MySQL ( , ):

SET NAMES utf8;
SET CHARACTER SET utf8;

, CHARACTER SET UTF-8.

.

+5

. , UTF-8.

, , , , windows-1552, , () UTF-8, .

, UTF-8.

UPDATE: , , :

MySQL UTF-8 my.cnf?

+2

More articles:


All Articles