You could look into running the DB on an OS that does support case insensitive collation. It'll likely perform better too.
On 16 January 2013 20:40, Marcel van Pinxteren < marcel.van.pinxte...@gmail.com> wrote: > From the Microsoft site I learned > http://msdn.microsoft.com/en-us/library/ms188046(v=sql.105).aspx > that they combine collation and "ComparisonStyle" to a collation name. > > I thought that case insensitivity had to be built into the collation, but > apparently MS built case sensitivity in the database engine. > This would mean that Postgresql would need to build case (in)sensitivity > into her engine as well. > > Judging from the small amount of discussion on this subject, I am afraid > this is not going to happen anytime soon. Alas, we will stay with SQL > Server then (or maybe MySQL, but I will have to investigate). > > Met vriendelijke groet, > > Marcel van Pinxteren > -------------------------- > Volg onze bouw op http://nieuwekampen.blogspot.com > > > On Wed, Jan 16, 2013 at 8:14 PM, Tom Lane <t...@sss.pgh.pa.us> wrote: > >> Marcel van Pinxteren <marcel.van.pinxte...@gmail.com> writes: >> > Therefore the question: are there plans to create a set of case >> > insensitive, and maybe also accent insensitive collations in the near >> > future? >> >> Not from the Postgres project -- we just use the collations supplied by >> the operating system. >> >> regards, tom lane >> > > -- If you can't see the forest for the trees, Cut the trees and you'll see there is no forest.
