Making SqlQueryMaker case-insensitive

[Jeff Mitchell]

Maximilian Kossick wrote:
> Documentation on MySql collation, but I think I found it myself. If
> the database is utf8_bin by default, you'll have to make each column
> referenced by addFilter/excludeFilter use utf8_uicode_ci, as these
> filters have to be case insensitive, e.g albums.name COLLATE
> utf8_unicode_ci like '%foo%' (I'm not sure if this example works, but
> all the Sql query makers have to be adapted like this)
> 
> See http://dev.mysql.com/doc/refman/5.0/en/charset-collate.html and
> http://dev.mysql.com/doc/refman/5.1/en/charset-collate-tricky.html

This is mostly gibberish to me as I know nothing about QueryMakers, much
less SqlQueryMakers. Is this something you can tackle?

--Jeff

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 261 bytes
Desc: OpenPGP digital signature
Url : http://mail.kde.org/pipermail/amarok-devel/attachments/20091025/26af3350/attachment.sig