Changes between Version 4 and Version 5 of MySqlDb

Timestamp:

Jan 31, 2007, 11:28:04 AM (17 years ago)

Author:

Christian Boos

Comment:

Document the constraint of having to use the utf8 character set for MySQL databases

MySqlDb

@@ -11 +11 @@
 == Requirements ==
 === MySQL ===
- ''to be completed from #3884''
+
+In order to avoid several issues related to the use of unicode characters throughout Trac, we '''''strongly''''' advise MySQL users to only use databases having the ''`utf8`'' character set and the ''`utf8_general_ci`'' collation type.
+
+Such databases can be created with the MySQL monitor, like that:
+{{{
+CREATE DATABASE trac DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; 
+}}}
+
+See also #3884.
+
 === MySQLdb ===
 The recommended version for now is MySQL-python 1.2.1_p2.