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#HConve....
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