Changes between Version 29 and Version 30 of DatabaseBackend

Timestamp:

Aug 17, 2007, 5:55:00 PM (17 years ago)

Author:

anonymous

Comment:

—

DatabaseBackend

@@ -80 +80 @@
 > ALTER DATABASE DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
 > quit
+
+NB - it may be necessary to use a different collation. In some cases, where there is a 
+case-sensitive collision between 2 files in svn (/myrepos/path/my.txt and /myrepos/path/MY.txt) 
+utf8_general_ci is case-*in*sensitive, so utf8_bin will allow case-sensitive keys. For example 
+> ALTER DATABASE DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
+If during index of respository you get 1062 - Duplicate Entry this may be a cause
+see ticket 3676 
+
 }}}
+
+
  * Run trac-admin to create a new Trac environment.  When prompted for a database connection string, use:
 {{{