Making SqlQueryMaker case-insensitive

[Jeff Mitchell]

Whoever may know this (probably Max),

In a branch I have code that updates the database to use utf8_bin
collation everywhere. This is a much-requested feature since it allows
for artists and albums and such with difference cases, but also became
necessary due to some other work I've been doing with scanning.

A side effect of this, however, is that normal queries now need to
specify if they want to be case-insensitive. It's as simple as adding
"COLLATE utf8_unicode_ci" on the end of the query, but I'm not sure
where to do it or the best way -- whether all SqlQueryMaker queries
should be run this way, or whether it should be an option/flag, or...?

I'd appreciate input (and hopefully code help) from someone that
actually knows what they're doing in SqlQueryMaker.

--Jeff

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