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

From Vincas Dargis
Subject Concerning about Unicode-aware string handling
Date
Msg-id CAPNCXk0q_hUN_gsKHNCYNWiJ=d+6RaStNknf-yfG8kvU9m196A@mail.gmail.com
Whole thread Raw
Responses Re: Concerning about Unicode-aware string handling
Re: Concerning about Unicode-aware string handling
List pgsql-general
Hello,

We have problems (currently using 8.4, but also in latest 9.1.3) in
our application with Unicode word symbols in Lithuanian ('ąčęėįšųūž'),
Russian and of course potentially other languages.

For example, regex_replace('acząčž', E'\\W', '', 'g') removes ąčž.

lower() and ~* comparison works only with locale that is set (no
internationalization).

Could we expect Unciode support in near future? Or should we do quick
hacks by reimplementing regexp_replace(), lower(), upper() and other
string SQL functions using, for example, Qt libraries..? Or maybe are
there some kind simpler workarounds?

Thank you,
Vincas.

pgsql-general by date:

Previous
From: Craig Ringer
Date:
Subject: Re: Postgresql segmentation fault at slot_deform_tuple
Next
From: John R Pierce
Date:
Subject: Re: Concerning about Unicode-aware string handling