Re: Non-C locale and LIKE - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Non-C locale and LIKE
Date
Msg-id 200411281435.iASEZwP22492@candle.pha.pa.us
Whole thread Raw
In response to Re: Non-C locale and LIKE  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
Peter Eisentraut wrote:
> Bruce Momjian wrote:
> > However, I am wondering if we should create a character lookup during
> > initdb that has the characters ordered so we can do:
> 
> That won't work.  Real-life collations are too complicated.

OK.

> > Also, we mention you should use the "C" locale to use normal indexes
> > for LIKE but isn't it more correct to say the encoding has to be
> > SQL_ASCII?
> 
> No, the locale decides the ordering.

Oh, OK.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


pgsql-hackers by date:

Previous
From: Thomas Hallgren
Date:
Subject: Re: Status of server side Large Object support?
Next
From: Christopher Kings-Lynne
Date:
Subject: Re: Error: column "nsptablespace" does not exist