Hi!
I have a database where all records are stored in UTF-8.
All data are stored/read with PHP script, files are stored in UTF-8, and first query after connecting to database is
mysql_query('SET CHARSET utf8', $this->sqlID);
mysql_query('SET NAMES utf8', $this->sqlID);
Now lets talk about SQLyog problems
Problem 1:
I can change whatever font I like, but still in table data window I see wrong encoding (i see some strange characters instead of the ones I need)
Problem 2:
When I export database from SQLyog (5.01) (tools -> export database as sql statements) and open exported file I see wrong encoding again (strange characters instead the ones I need). When I try to import this file I get wrong encoding in the end when i try to query for these data
If i do the same with mysql dump
Code:
c:mysqlbinmysqldump -uroot -p mydatabase –character-set utf8 –default-character-set utf8 –add-drop-table –lock-tables > c:/test.sql
when i open file encoding is ok, and when i import this file and query for the data encoding is ok
I hope you understood the problem. If you need I can send some screenshots or database export files (the one form SQLyog and the one from mysql dump)
EDIT: mysql dump works correctly even if i remove these lines: –character-set utf8 –default-character-set utf8
