Changes between Version 13 and Version 14 of MySqlDb

Timestamp:

Mar 30, 2007, 3:02:26 PM (17 years ago)

Author:

techtonik <techtonik@…>

Comment:

+ some more information to help debugging MySQL issues

MySqlDb

@@ -9 +9 @@
 === MySQL ===
 
-In order to avoid several issues with unicode and international characters throughout Trac, we '''''strongly''''' advise MySQL users to only use databases having the ''`utf8`'' character set and the ''`utf8_general_ci`'' collation type. However, some of Trac indexes in utf8 are incompatible with MySQL 4.1.x, so anything before MySQL 5.0.x will just not work in this configuration.
+In order to avoid several issues with unicode and international characters throughout Trac, we '''''strongly''''' advise MySQL users to only use databases having the ''`utf8`'' character set and the ''`utf8_general_ci`'' collation type. However, prior to [milestone:0.10.4] some of Trac indexes in ''utf8'' are incompatible with MySQL 4.1.x (too big), so anything before MySQL 5.0.x just will not work in this configuration.
 
 Such databases can be created with the MySQL monitor, like that:
 {{{
 CREATE DATABASE trac DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; 
+}}}
+
+To check what are the settings for your database, issue command:
+{{{
+mysql> USE TRAC;
+Database changed
+mysql> SHOW VARIABLES LIKE '%character%';
++--------------------------+--------------------
+| Variable_name            | Value
++--------------------------+--------------------
+| character_set_client     | cp1251
+| character_set_connection | cp1251
+| character_set_database   | utf8
+| character_set_filesystem | binary
+| character_set_results    | cp1251
+| character_set_server     | utf8
+| character_set_system     | utf8
+| character_sets_dir       | C:\DevServer\Instal
++--------------------------+--------------------
+8 rows in set (0.00 sec)
+mysql>
 }}}