You are here: Home » Topic » change case sensitivity in the database change case sensitivity in the database FireFly Media Server (formerly mt-daapd) › Firefly Media Server Forums › Firefly Media Server › General Discussion › change case sensitivity in the database This topic contains 2 replies, has 2 voices, and was last updated by fizze 9 years, 10 months ago. Log In Register Lost Password Viewing 3 posts - 1 through 3 (of 3 total) Author Posts 6th May 2008 at 3:42 am #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 6th May 2008 at 10:19 am #16961 EVILRipperParticipant 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. 6th May 2008 at 12:07 pm #16962 fizzeParticipant 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 Log In Register Lost Password Viewing 3 posts - 1 through 3 (of 3 total) You must be logged in to reply to this topic.