From: | Grzegorz Mucha <mucher(at)tigana(dot)pl> |
---|---|
To: | Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Re: Latin2 and Unicode problems |
Date: | 2001-04-20 07:56:34 |
Message-ID: | 01042009563400.04680@theta |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> I'm confused. Did you enable the locale support only?
Sorry then. Well, I tested two cases:
- pg compiled only with enable locale and iso8859-2 works
- pg compiled with locale, enable unicode and unicode conversion doesn't
work as it should.
> That's because locale support (--enable-locale) does not consider
> about the Unicode support. (that's not the locale support's fault,
> since it was developped before the Unicode support appears). When you
> create the unicode database, everything is represented in the UTF-8
> encoding. However, the locale support thinks that it is ISO 8859-2 (in
> your case) and it try to do the case conversion using the ISO 8859-2
> locale. As a result, you see invalid UTF-8 sequences.
>
> Does it match your situation?
Actually, that may be it. I stopped getting the messages after compiling
without locale support, but with Unicode. But there is still the problem
of not working sorting and conversions. Only option I can think of would
be to somehow set the system locale to pl_PL.UTF-8 (I don't even know if
there's such option). Please let me know if there is another way to do it.
--
Grzegorz Mucha <mucher(at)tigana(dot)pl> ICQ #91619595, tel.(502)261417
----------------------------------------------------------------
Quidquid id est, timeo Danaos et dona ferentes.
Wergiliusz, "Eneida"
From | Date | Subject | |
---|---|---|---|
Next Message | postgres | 2001-04-20 08:01:31 | monitor postgres connect session |
Previous Message | Tatsuo Ishii | 2001-04-20 07:05:02 | Re: Re: Latin2 and Unicode problems |