Re: Disabling case sensitivity

From: "Jan D'Hondt" <jandhondt(at)jadesoft(dot)be>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Disabling case sensitivity
Date: 2002-07-19 12:43:23
Message-ID: ah91eg$1l2l$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

MS SQL server stores 'Stphane' as 'Stphane' which is exactly what people
would want. Your email server on the other hand...

Jan D'Hondt

Stephane Bortzmeyer <bortzmeyer(at)nic(dot)fr> schreef in berichtnieuws
20020710125119(dot)GA15584(at)nic(dot)fr(dot)(dot)(dot)
> On Tue, Jul 09, 2002 at 04:11:38PM -0700,
> igor <linux_211(at)hotmail(dot)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 'Stphane' to
> 'STEPHANE'?
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message mallah 2002-07-19 12:46:38 Re: Long update progress
Previous Message Andy Marden 2002-07-19 12:31:52 Long update progress

Browse pgsql-general by date

  From Date Subject
Next Message Steve Brett 2002-07-19 12:46:36 Re: References for PostgreSQL
Previous Message Tom Jenkins 2002-07-19 12:42:19 Re: References for PostgreSQL