Changes between Version 44 and Version 45 of MySqlDb
- Timestamp:
- Aug 28, 2009, 12:42:16 AM (15 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
MySqlDb
v44 v45 20 20 It seems that some users were using the [http://askmonty.org/wiki/index.php/MariaDB MariaDB] variant of MySQL, but again, no guarantees. 21 21 22 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. All tables MUST be created as '''InnoDB''' or '''NDB''' type tables, because Trac uses transaction mechanism thatnot supported by MyISAM tables (see [comment:ticket:8067:5] and [http://dev.mysql.com/tech-resources/articles/storage-engine/part_3.html MySQL docs]).22 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. All tables MUST be created as '''InnoDB''' or '''NDB''' type tables, because Trac uses a transaction mechanism that is not supported by MyISAM tables (see [comment:ticket:8067:5] and [http://dev.mysql.com/tech-resources/articles/storage-engine/part_3.html MySQL docs]). 23 23 24 Proper database can be created with the MySQL monitor, like that:24 A proper database can be created with the MySQL monitor, like this: 25 25 {{{ 26 26 CREATE DATABASE trac DEFAULT CHARACTER SET utf8 COLLATE utf8_bin; 27 27 }}} 28 28 29 To check character set settings for your database, issue command:29 To check character set settings for your database, issue the following commands: 30 30 {{{ 31 31 mysql> USE trac;