Re: Disabling case sensitivity - Mailing list pgsql-general

From Jan D'Hondt
Subject Re: Disabling case sensitivity
Date
Msg-id ah91eg$1l2l$1@news.hub.org
Whole thread Raw
In response to Re: Disabling case sensitivity  (Stephane Bortzmeyer <bortzmeyer@nic.fr>)
List pgsql-general
MS SQL server stores 'St�phane' as 'St�phane' which is exactly what people
would want. Your email server on the other hand...


Jan D'Hondt


Stephane Bortzmeyer <bortzmeyer@nic.fr> schreef in berichtnieuws
20020710125119.GA15584@nic.fr...
> On Tue, Jul 09, 2002 at 04:11:38PM -0700,
>  igor <linux_211@hotmail.com> wrote
>  a message of 12 lines which said:
>
> > I would like to know if there is some way how to disable case
> > sensitivity in PostgreSQL server.
>
> Always remember that case-INsensitivity is properly defined only for
> US-ASCII. Many PostgreSQL users store data in other scripts like
> Latin-1.
>
> > Exactly like in MS SQL server.
>
> What does MS SQL server does with Unicode? Does it map 'St�phane' to
> 'STEPHANE'?
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org



pgsql-general by date:

Previous
From: "Andy Marden"
Date:
Subject: Long update progress
Next
From: "Andy Marden"
Date:
Subject: Re: [ADMIN] Long update progress