viernes, 29 de abril de 2011

UTF-8 en PHP y MySQL

- UTF8, PHP and MySQL – Rob Allen's DevNotes
- Web-O-Blog: PHP, MySQL and UTF-8 encoding
- Converting Character Sets - MySQL Performance Blog

Algunos ejemplos:
1. para PDO:
use PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES "utf8''
http://framework.zend.com/issues/browse/ZF-1541

2. para Zend DB:
http://blog.welmers.net/bastiaan/2008/12/zend_db-and-utf-8.html

4 comentarios:

  1. Do not forget always to save your files in UTF-8 without BOM in the text editors! This is true for JavaScript, HTML, and PHP files. CSS files are less likely to contain special characters, but consistency never hurts.

    ResponderEliminar
  2. as of Zend Framework 1.8 at least. You can use:
    database.params.charset = utf8

    ResponderEliminar
  3. Definir el charset y collation por defecto en my.ini. Poner en el apartado correspondiente:

    [mysqld]
    character-set-server=utf8
    collation-server=utf8_unicode_ci

    [mysql]
    default-character-set=utf8
    default-collation=utf8_unicode_ci

    ---
    Y algunas indicaciones para symfony

    ResponderEliminar