qt 4.7.3 mysql 5.1.58 таблица - utf8 - default collation
Хочу qt подружить с mysql. Но пока не могу заставить mysql правильно выводить кириллицу. SET NAMES 'utf8'; перед запросами не помогает.
mysql> INSERT INTO smkp.camroom (idcamroom, room) VALUES (3, 'fdfвава'); Query OK, 1 row affected, 1 warning (0.05 sec)
mysql> SELECT * FROM smkp.camroom;
+----------------+----------+
| idcamroom | room |
+----------------+----------+
|____1____ | ??????? |
| ____2 ____ | fdf???? |
|____3_____| fdf???? |
|____13____| dfgh???? |
|____160___ | ??? |
+-----------------+----------+
mysql> SHOW COLLATION like 'utf%';
+--------------------+---------+-----+---------+----------+---------+
| Collation | Charset | Id | Default | Compiled | Sortlen |
+--------------------+---------+-----+---------+----------+---------+
| utf8_general_ci | utf8 | 33 | Yes | Yes | 1 |
| utf8_bin | utf8 | 83 | | Yes | 1 |
| utf8_unicode_ci| utf8 | 192 | | Yes | 8 |
mysql> SHOW VARIABLES like «char%»;
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
Может кто сталкивался.
