Re: Regular expressions w localization problem

From: Manuel Sugawara <masm(at)fciencias(dot)unam(dot)mx>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Regular expressions w localization problem
Date: 2005-11-25 19:19:41
Message-ID: m3veygzgaa.fsf@conexa.fciencias.unam.mx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2005-11-25 19:21:01 Re: Regular expressions w localization problem
Previous Message Gregory Youngblood 2005-11-25 17:36:27 Resend: Question about PostgreSQL, pgpool, and Postfix