On Mon, Oct 6, 2008 at 9:27 PM, Krishnan Mani <krishnanm75@yahoo.com> wrote:
1.4.3 The MySQL server is it configured to use UNICODE?
NB: mysqld service must be started. In a Terminal window, type the command mysql, then an SQL to display variables content server configuration. Text of query:
show where variable_name variables like 'char%'; UNQUOTE
In mysql that i have, I get this: mysql> SHOW VARIABLES LIKE 'character\_set\_%'; +--------------------------+--------+ | Variable_name | Value | +--------------------------+--------+ | character_set_client | latin1 | | character_set_connection | latin1 | | character_set_database | latin1 | | character_set_filesystem | binary | | character_set_results | latin1 | | character_set_server | latin1 | | character_set_system | utf8 | +--------------------------+--------+ 7 rows in set (0.00 sec) So even though my system is utf8, mysql databases are being created in latin1. Is my understanding correct? Thanks.