On Wed, Dec 10, 2014 at 09:49:49PM +0100, Lars Ellenberg wrote:
> On Sun, Nov 30, 2014 at 09:56:19PM +0300, Paul A. Gusev wrote:
> > Hi!
> > Today i have some troubles with mysql backend.
> > If you make two files with name in different registers (i.e. 1.jpg
> > and 1.JPG) in the same directory , csync2 cannot work corretly.
> Works for me, though.
> Which mysql version?
> Is your mysql db / table created with some insensitive "collate" setting?
> It should be created with a binary (or case sensitive) collate setting.
> Maybe we should change the create database statement to explicitly
> include that, instead of putting a BINARY in every sql statement?
> Can you check if that works for you, too?
Hm. No, that alone would not do it, considering trailing space padding :-(
The create table statements needs to be changed to "TEXT BINARY NOT NULL".
That should be good enough.
Csync2 mailing list