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@tigana.pl> ICQ #91619595, tel.(502)261417
> ----------------------------------------------------------------
> An optimist is a man who looks forward to marriage.
> A pessimist is a married optimist