You are here: Home » Topic » change case sensitivity in the database

change case sensitivity in the database

This topic contains 2 replies, has 2 voices, and was last updated by  fizze 9 years, 6 months ago.

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #2420

    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

    #16961

    EVILRipper
    Participant

    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.

    #16962

    fizze
    Participant

    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.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.