Re: Problems with Polish locale

[Cced: to hackers list]

Can you turn off --enable-locale or set locale to C and try again? I
guess upper() does bad thing in that it thinks the letter is Polish
but actually it is unicode(UTF-8).
--
Tatsuo Ishii

> I have encountered some problems while trying to create a database that
> would use the Polish locale.
> After compiling with --enable-multibyte --enable-locale
> --enable-unicode-conversion, I initdb-ed postgres with -E UNICODE and
> started the database (the correct locale was set - pl_PL).
>
> However, upon connecting to psql, using \encoding LATIN2 (as suggested by
> the iso8859-2 locale) and doing a test :
> SELECT upper('acelnoszx'); (these are Polish national chars (0x81 etc.),
> not the ASCII
> ones), I keep getting the message:
>
> utf_to_latin: could not convert UTF-8 (0xc3a3) ignored
> (repeated 3x for different chars).
>
> The letters are not converted to uppercase, either.
>
> When using LATIN2 at initdb it works fine (Unfortunately I need an UTF-8
> database for the i18n issues with Tcl8.x), so Unicode support is a must.
>
> Any hints? (That was tried with PG7.1RC1 and Beta 5)
>
> --
> Grzegorz Mucha <mucher(at)tigana(dot)pl> ICQ #91619595, tel.(502)261417
> ----------------------------------------------------------------
> An optimist is a man who looks forward to marriage.
> A pessimist is a married optimist