Re: [Csync2] csync2-2.0 ans mysql backend

[Гусев Павел]

Good stuff! Thank you very much, this idea better than my)  

 

--
С уважением,

Гусев Павел

Руководитель отдела системного администрирования

 

QSOFT | Ведущий web-интегратор

 

офис 7(495) 771-7363 #110 | моб. 7(926) 850-1108

pgu...@qsoft.ru  

Москва, Авангардная улица, 3  |  qsoft.ru

San Francisco, 222 Columbus Ave |  qsoftus.com

 

 

 

10.12.2014, 23:56, "Lars Ellenberg" <lars.ellenb...@linbit.com>:

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.

Thanks,
        Lars

_______________________________________________
Csync2 mailing list
Csync2@lists.linbit.com
http://lists.linbit.com/mailman/listinfo/csync2

_______________________________________________
Csync2 mailing list
Csync2@lists.linbit.com
http://lists.linbit.com/mailman/listinfo/csync2