Thank you very much Thomas, that script rocks!
In my development machine, it has worked trouble-freely. And indeed the simple SpaceIndex has stopped confusing cases afterwards. But may other things will do. However, the script issued a number of errors: > ERROR 1025 (HY000) at line 1: Error on rename of './curriki1_15/#sql-1e1f_a8' > to './curriki1_15/xwikiproperties' (errno: 150) (which constraint-integrity violations) And indeed, the tables are not with the right collation keys there. Is there anything else bad I should fear about these errors? Do I have a way to avoid them? Or to know more about them? thanks in advance. paul On 25 oct. 2014, at 10:59, Thomas Mortagne <[email protected]> wrote: > Yes your issue sounds like wrong MySQL encoding/collation (which is an > easy mistake since the default MySQL setup is wrong for XWiki). The > right one is utf8_bin. > > You might be interested by > http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationMySQL#HConvertadatabasefromlatin128orcollationutf8_ci29toutf82Futf8_bin. > > On Sat, Oct 25, 2014 at 12:05 AM, Paul Libbrecht <[email protected]> wrote: >> Hello XWiki experts, >> >> we seem to be encountering a few HQL queries which return us document names >> with the wrong casing! E.g. richard instead of Richard. >> >> One case where we do not even have any curriki specific is >> Main/SpaceIndex?space=Coll_anntoniaowens which shows documents of >> Coll_AnntoniaOwens (only). >> >> Is there something I can suspect for this issue? >> Would there be somewhere a case-insensitivty default in MySQL? (the question >> at http://stackoverflow.com/questions/7857669/mysql-case-sensitive-query >> seems to say so). However changing SQL is not really an option. >> >> thanks in advance. >> >> Paul >> >> _______________________________________________ >> devs mailing list >> [email protected] >> http://lists.xwiki.org/mailman/listinfo/devs > > > > -- > Thomas Mortagne > _______________________________________________ > devs mailing list > [email protected] > http://lists.xwiki.org/mailman/listinfo/devs _______________________________________________ devs mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/devs
