Problems displaying encoded UTF-8 content from a database

Question

Dear Stackoverflow Community Members,

We are developing a web application using the Zend Framework, and we are encountering some coding problems that we hope can help us solve. The situation looks something like this: in MySQL there are certain database tables that should be displayed as html. Because the site was developed using Spanish, the database contains some characters, such as "á", or "-". Our internal policy is to set all encodings as UTF-8, including all databases and tables. The problem is that when we get the contents from the database, some characters are displayed as question marks.

We have no ideas. This is all that we have already tried and double checked: 1. The SQL file from which we load all the data is correctly encoded by UTF-8. 2. SQL is loaded via phpmyadmin (which is configured as UTF-8), and the resulting tables are displayed correctly. 3. The netbeans environment used for encoding is also installed as UTF-8.

It is strange that all content hardcoded either as php or html is displayed correctly. Only values ​​that are retrieved from the database have problems.

Any ideas?

Many thanks.

Answer 1

do you use

resources.db.params.charset = "utf8" 

in your configuration file e.g. (application.ini)?

Answer 2

- . , utf8_encode() ? UTF-8 - ?

Answer 3

? CLI mysqldump phpmyadmin?

, ( DB SELECT INSERT).

mysqldump --set-character-set=latin-1 --set-charset -u user -pPASSWORD databasename > databasename-latin1.sql

: http://www.saiweb.co.uk/mysql/converting-mysql-latin1-to-utf8

Answer 4

, , :

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

, UTF-8 . .

Answer 5

, utf-8, sql

"SET NAMES 'utf8';"

Answer 6

, . . :

• (.. SET NAMES 'utf8')
• Zend: resources.view.encoding = "UTF-8"
• Apache

, , , . .htaccess:

addDefaultCharset utf-8

Answer 7

,

• Php 5.3
• PDO

, pdo PDO:: MYSQL_ATTR_INIT_COMMAND , :

try {
    $pdbo = new PDO("mysql:host=localhost;dbname=test", 'root', '', array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8"));
}catch(PDOException $e){
    echo $e->getMessage();
}

: http://bugs.php.net/bug.php?id=47224

: Mysqli .