Postgres Pro
Downloads
Home   >   mailing lists

Re: Case insensitive collation - Mailing list pgsql-general

From Marcel van Pinxteren
Subject Re: Case insensitive collation
Date
Msg-id CAE3e+fPOMjSm5MVNvg8HiA7b1rLq0rnFbRY8jF0OW+P0NwYjRw@mail.gmail.com
Whole thread Raw
In response to Re: Case insensitive collation  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Case insensitive collation
List pgsql-general
Tree view
From the Microsoft site I learned
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@sss.pgh.pa.us> wrote:
Marcel van Pinxteren <marcel.van.pinxteren@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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Case insensitive collation
Next
From: Robert James
Date:
Subject: Best method to compare subdomains