Re: Concerning about Unicode-aware string handling - Mailing list pgsql-general

From Vincas Dargis
Subject Re: Concerning about Unicode-aware string handling
Date
Msg-id CAPNCXk268raC5nHe0PyXHB6gE_XSWjTVnZu+KBkEPQnkNM8xaw@mail.gmail.com
Whole thread Raw
In response to Concerning about Unicode-aware string handling  (Vincas Dargis <vindrg@gmail.com>)
Responses Re: Concerning about Unicode-aware string handling
List pgsql-general
Sorry I have to write "manual" replay since I've messed up mailing
list settings (got "Partial Digest"...).

John R Pierce wrote:
> your database encoding is UTF8 ? the language or environment you're using to generate those strings such as 'acząčž'
isalso UTF8 ? 


Database created using:
initdb -D ../data -E utf-8 -U postgres

I have to take back statements about "lower()" and "~*" - they do not
work only for (strange) clusters created with "--no-locale".

But regexp_replace issue is still there. Regexp "\w" understands only
as "ascii word character" ?

pgsql-general by date:

Previous
From: Vincas Dargis
Date:
Subject:
Next
From: "Albe Laurenz"
Date:
Subject: Re: Concerning about Unicode-aware string handling