On 05/25/2014 11:36 PM, Joseph wrote: > > Yes, it worked, and I get: > CREATE DATABASE `catalog_sys` /*!40100 DEFAULT CHARACTER SET utf8 */ > > so it looks OK I think. >
Yeah, looks good. Here's what I'm using as a test case. Your columns aren't regular 'char' types, are they? mysql> CREATE DATABASE utf8_test; Query OK, 1 row affected (0.02 sec) mysql> CREATE TABLE dummy ( name varchar(255) NOT NULL ); Query OK, 0 rows affected (0.05 sec) mysql> INSERT INTO dummy ( name ) VALUES ( 'Bâtiment' ); Query OK, 1 row affected (0.00 sec) mysql> SELECT * FROM dummy; +-----------+ | name | +-----------+ | Bâtiment | +-----------+ 1 row in set (0.00 sec) Are you running your tests from the command line, or through phpMyAdmin? If it's the latter, it could be PHP's fault and not MySQL's. Related: I don't think this has anything to do with your current issue, but just as a PSA, "utf8" in mysql doesn't support all of unicode: http://mathiasbynens.be/notes/mysql-utf8mb4
