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
Show quoted text
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
Import Notes
Reply to msg id not found: 01032312403000.30832@thetaReference msg id not found: 01032312403000.30832@theta