Changes between Version 16 and Version 17 of MySqlDb
- Timestamp:
- Oct 26, 2007, 4:51:46 AM (17 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
MySqlDb
v16 v17 15 15 CREATE DATABASE trac DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; 16 16 }}} 17 18 XXX: I think the above advice on collations is wrong - using a case-insensitive collation does not sound right, and when I used the above command, the indexing process failed when it came to insert a revision which included changes to files with names differing only in case. Recreating the db using the utf8_bin collation allowed things to work as expected. 17 19 18 20 To check character set settings for your database, issue command: