Re: Case insensitive collation

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(dot)van(dot)pinxteren(at)gmail(dot)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 <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
>> Marcel van Pinxteren <marcel(dot)van(dot)pinxteren(at)gmail(dot)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.