Making SqlQueryMaker case-insensitive

[Jeff Mitchell]

Jeff Mitchell wrote:
> 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?

Ahh, never mind -- this was easy to follow...done!

--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/4310a53e/attachment.sig