Hi, 

sorry for digging out this old thread, but I found a solution which
might help someone and should possibly inserted into Trac.

On Mon, 2009-02-02 at 14:49 -0800, Noah Kantrowitz wrote:
> When using MySQL, you should be using the utf8_bin collation, since Trac
> assumes that DB is case-sensitive.

This is actually not enough. This still leaves key over the path column
in the node_change db case INsensitive. 

According to several discussions on the MySQL List [1], one has to add
the BINARY attribute to a field to make it case sensitive. After adding
this Trac resynced correctly with my SVN repository.

I believe this is a Bug in the table definition of Trac which is only
triggered if one performs the same action in the same revision on two
files which only differ in the case of the characters (most likely not
often to happen).

Hope that will help someone.

Daniel



[1] http://lists.mysql.com/mysql/170390



--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Trac 
Users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to 
[email protected]
For more options, visit this group at 
http://groups.google.com/group/trac-users?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to