[Koha-bugs] [Bug 6132] System preferences are case sensitive

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6132

M. de Rooy <m.de.rooy at rijksmuseum.nl> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |m.de.rooy at rijksmuseum.nl
       Patch Status|Needs Signoff               |Failed QA

--- Comment #2 from M. de Rooy <m.de.rooy at rijksmuseum.nl> 2011-08-11 08:10:43 UTC ---
The idea of this patch sounded very good! Unfortunately, this patch does not
really make a difference.
Just test this without your patch:
use C4::Context;
print C4::Context->preference('OPACNAV')."\n";

It will print the OpacNav pref too. Why?
Because MySQL uses the utf8_general_ci collation here and that collation is
case insensitive. So the statement with LOWER(variable)=? is not needed.

So, more interesting is now: Where did you have problems with the case of prefs
in Koha? Should we do something else there?

-- 
Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the QA Contact for the bug.