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.pinxteren@xxxxxxxxx> wrote:
From the Microsoft site I learnedthat 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.comOn Wed, Jan 16, 2013 at 8:14 PM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:Marcel van Pinxteren <marcel.van.pinxteren@xxxxxxxxx> writes:Not from the Postgres project -- we just use the collations supplied by
> Therefore the question: are there plans to create a set of case
> insensitive, and maybe also accent insensitive collations in the near
> future?
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.
