Thread: Postgres and Unicode

Postgres and Unicode

From
Grzegorz Mucha
Date:


I still haven't got rid of the problem with ISO 8859-2 charset and
Postgres. While I may use the database with correct Polish locale (by
using only --enable-locale) it is still impossible (in 7.1) to use unicode
encoding with Polish chars.

I have tried every possible combination of compile/init parameters and it
doesn't work either - there are problems with upper/lower functions. and
collation order.

Any else suggestions?
--
Grzegorz Mucha <mucher@tigana.pl> ICQ #91619595, tel.(502)261417
----------------------------------------------------------------
Quidquid id est, timeo Danaos et dona ferentes.
                    Wergiliusz, "Eneida"

Re: Postgres and Unicode

From
Tatsuo Ishii
Date:
> I still haven't got rid of the problem with ISO 8859-2 charset and
> Postgres. While I may use the database with correct Polish locale (by
> using only --enable-locale) it is still impossible (in 7.1) to use unicode
> encoding with Polish chars.
>
> I have tried every possible combination of compile/init parameters and it
> doesn't work either - there are problems with upper/lower functions. and
> collation order.

I don't think ISO 8859-2 collation would work if you store data as
Unicode into the database since it's Unicode.
--
Tatsuo Ishii