Changes between Version 60 and Version 61 of MySqlDb

Timestamp:

Feb 10, 2012, 12:17:56 AM (12 years ago)

Author:

Christian Boos

Comment:

document #9766 (utf8mb4)

MySqlDb

@@ -18 +18 @@
 The recommended versions of MySQL are those from 5.0.x series.
 It might work with 4.1.x or 6.0.x, but no guarantees.
-The [http://askmonty.org/wiki/index.php/MariaDB MariaDB] variant of MySQL works as well (tested MariaDB 5.3.3, MySQLdb 1.2.3 and Trac 0.12.3rc1).
+The [http://askmonty.org/wiki/index.php/MariaDB MariaDB] variant of MySQL works as well (tested MariaDB 5.3.3, MySQLdb 1.2.3 and Trac 0.12.3).
 
 In order to avoid Unicode and international characters problems in Trac (e.g., international characters turning into question marks with mysterious **"Incorrect string value"** errors logged), the Trac database MUST be configured  with the ''`utf8`'' character set and the ''`utf8_bin`'' collation type.
@@ -27 +27 @@
 {{{
 CREATE DATABASE trac DEFAULT CHARACTER SET utf8 COLLATE utf8_bin; 
+}}}
+
+With MySQL version 5.5.3 and up, you can also select the [http://dev.mysql.com/doc/refman/5.5/en/charset-unicode-utf8mb4.html mb4] variant of utf8, which enables you to store any Unicode character, not only those in the [WikiPedia:Basic_Multilingual_Plane Basic Multilingual Plane]. Note that you'll need at least Trac 0.12.3 for this (#9766).
+{{{
+CREATE DATABASE trac DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_bin; 
 }}}
 
@@ -78 +83 @@
 
 === MySQLdb ===
-The recommended version is MySQL-python 1.2.2 or 1.2.3, which must be compiled in ''thread-safe client'' mode.
-Earlier versions are known to be problematic.
+The recommended version is MySQL-python 1.2.3, which must be compiled in ''thread-safe client'' mode. The older version 1.2.2 also works but please don't use earlier versions which are known to be problematic.
 
 See http://cheeseshop.python.org/pypi/MySQL-python/1.2.2, which contains links to the .tar.gz source distribution as well as pre-built Windows eggs, but for Python 2.5 only as of this writing. Python 2.6 binaries for windows can be found [http://www.codegood.com/archives/4 here] (unofficial site).
@@ -152 +156 @@
 There are a few possibilities:
  1. Try first to login on the command-line using the user `tracuser` (`mysql -p -h localhost -u tracuser`)
- 1. Created user is not yet used by MySQL (Login to the MySQL server (as root) with`mysql -p` and type: `FLUSH PRIVILEGES;`)
+ 1. Created user is not yet used by MySQL (Login to the MySQL server (as root) with `mysql -p` and type: `FLUSH PRIVILEGES;`)
  1. The user is added but the host does not match in the MySQL user table (occurred on a FreeBSD setup). Correct this with: `mysql -p; use mysql; UPDATE user SET Host="localhost" WHERE User="tracuser"; FLUSH PRIVILEGES;`