Skip site navigation (1) Skip section navigation (2)

Re: [9.1beta1] UTF-8/Regex Word-Character Definition excluding accented letters

From: "David Johnston" <polobo(at)yahoo(dot)com>
To: "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: [9.1beta1] UTF-8/Regex Word-Character Definition excluding accented letters
Date: 2011-05-31 13:59:03
Message-ID: 009701cc1f9a$e701c7e0$b50557a0$@yahoo.com (view raw or flat)
Thread:
Lists: pgsql-general
Got it.  Changing LC_CTYPE to " English_United States.1252" restores the
correct behavior.

Thanks.

David J.

> -----Original Message-----
> From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
> Sent: Monday, May 30, 2011 10:40 PM
> To: David Johnston
> Cc: pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] [9.1beta1] UTF-8/Regex Word-Character Definition
> excluding accented letters
> 
> "David Johnston" <polobo(at)yahoo(dot)com> writes:
> > PostgreSQL 9.1beta1, compiled by Visual C++ build 1500, 64-bit
> > (EnterpriseDB Install Executable)
> 
> > CREATE DATABASE betatest
> >                 TEMPLATE template0
> >                 ENCODING 'UTF8'
> >                 LC_COLLATE 'C'
> >                 LC_CTYPE 'C';
> 
> > CREATE DOMAIN idcode AS text
> >                 NOT NULL CHECK (VALUE ~* '^\w[-:\w]*$') ;
> 
> > SELECT 'AAAAAéaaaaa'::idcode; // -> SQL Error: ERROR:  value for
> > domain idcode violates check constraint "idcode_check" (note the
> accented “e”
> > between all the “A”s)
> 
> AFAICS that's correct behavior.  C locale should not think that é is a
letter.
> 
> > This is running just fine against a 9.0 install on the same machine.
> 
> We made some strides towards getting locale-sensitive stuff to work as it
> "should" in 9.1.  In particular, platform-specific creative
interpretations of
> what C locale means shouldn't happen anymore ...
> 
> 			regards, tom lane


In response to

pgsql-general by date

Next:From: David JohnstonDate: 2011-05-31 14:24:41
Subject: Re: Function Column Expansion Causes Inserts To Fail
Previous:From: andrejDate: 2011-05-31 13:55:05
Subject: Re: Regular disk activity of an idle DBMS

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group