change case sensitivity in the database

[dkharas]

Hi is there a way to make the database case insensitive. I am loathing the prospect of having to fix all my ID3 tags.

thanks
Dave

[EVILRipper]

Don’t think so. However, you could try a very bitchy query to grab each value, cast it to lowercase, and write it back.

Nasty hack, but should fix your problem. Bad part is that everything would be lowercase.

[fizze]

Well, and only until you trigger the next full rescan.
I’ve tried to come up with a database-cleaning script, but SQLite doesnt make this job easier.

I’ve still got the ref cursor, so if you want to take it from there, you’re welcome.

[Author]

Posts