Re: Regular expressions w localization problem - Mailing list pgsql-general

From Manuel Sugawara
Subject Re: Regular expressions w localization problem
Date
Msg-id m3veygzgaa.fsf@conexa.fciencias.unam.mx
Whole thread Raw
In response to Re: Regular expressions w localization problem  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tom Lane <tgl@sss.pgh.pa.us> writes:

> I believe the meanings of [[:upper:]] and friends depend on the
> database locale,

Indeed they depend on the locale settings, that's why this used to
work.

> and the current code for them probably doesn't work at all in
> multibyte database encodings either.  So, what locale and encoding
> are you using?

The locale is es_MX and encoding latin1. (UTF-8 doesn't play very well
with regular expressions :-().

Regards,
Manuel.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Regular expressions w localization problem
Next
From: John Taber
Date:
Subject: Re: pg_connect troubles on localhost