Quote:
Is this database-related ?
Yes it is!
You can read her for instance: http://dev.mysql.com/doc/refman/4.1/en/charset.html . It is similar for mySQL 4.1 and 5.0. And much different than 3.23 and 4.0!
With MySQL 4.1 and 5.0 SQLyog starts querying the server for the default character set. However ' the default character set' is only a DEFAULT character set. You might have data that don't follow defaults. For instance if data were created when you had other defaults or if they were imported from another server having other defaults.
There are default character sets (and collations) for the server, for each database, for each table and for each column! So you can have one column in Chinesse and another in English (even 😀 – believe it or not but somebody use that ridiculous language! ).
You can most easily change the default character set for the server with MySQL Administrator” from http://dev.mysql.com . From the left-hand menu it is “startup variables” .. “advanced” tab. See attached. The server must be restarted for the changes to take effect. Charsets for Databases, tables and columns are defined with a CREATE or ALTER statement.
