[xwiki-devs] HQL case-insensitive queries?
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
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 <paul@hoplahup.net> 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 devs@xwiki.org http://lists.xwiki.org/mailman/listinfo/devs
-- Thomas Mortagne
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 <thomas.mortagne@xwiki.com> 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 <paul@hoplahup.net> 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 devs@xwiki.org http://lists.xwiki.org/mailman/listinfo/devs
-- Thomas Mortagne _______________________________________________ devs mailing list devs@xwiki.org http://lists.xwiki.org/mailman/listinfo/devs
Sorry I'm not really an expert on this script, just know it was used in cases like this. Le 27 oct. 2014 18:41, "Paul Libbrecht" <paul@hoplahup.net> a écrit :
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 <thomas.mortagne@xwiki.com> 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 <paul@hoplahup.net>
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 devs@xwiki.org http://lists.xwiki.org/mailman/listinfo/devs
-- Thomas Mortagne _______________________________________________ devs mailing list devs@xwiki.org http://lists.xwiki.org/mailman/listinfo/devs
_______________________________________________ devs mailing list devs@xwiki.org http://lists.xwiki.org/mailman/listinfo/devs
participants (2)
-
Paul Libbrecht -
Thomas Mortagne