You are here: Home » Topic » change case sensitivity in the databasechange case sensitivity in the databaseFireFly Media Server (formerly mt-daapd) › Firefly Media Server Forums › Firefly Media Server › General Discussion › change case sensitivity in the databaseThis topic has 2 replies, 3 voices, and was last updated 12 years, 5 months ago by fizze.Viewing 3 posts - 1 through 3 (of 3 total) AuthorPosts 6th May 2008 at 3:42 am #2420 dkharasGuest 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 6th May 2008 at 10:19 am #16961 EVILRipperParticipantDon’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. 6th May 2008 at 12:07 pm #16962 fizzeParticipantWell, 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.AuthorPostsViewing 3 posts - 1 through 3 (of 3 total)The forum ‘General Discussion’ is closed to new topics and replies.