Re: Win1250 database under linux - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Win1250 database under linux
Date
Msg-id 1869.1114877303@sss.pgh.pa.us
Whole thread Raw
In response to Win1250 database under linux  (Damir Bijuklic <damirbijuklic@yahoo.com>)
List pgsql-bugs
Damir Bijuklic <damirbijuklic@yahoo.com> writes:
> I'm using WIN1250 locale on both databases.

Does your Linux platform even have such a locale?  Mine doesn't.
("locale -a" will show you what is supported.)  I suspect your
machine is not recognizing the LANG setting and is falling back
to behave as though the locale is POSIX.

> Client is java, and no special SET commands are
> executed on connection... Don't know other specifich
> which would be useful.

AFAIK, Java does not do WIN1250, only Unicode.

You would probably be best off using Unicode (UTF8) encoding and some
suitable locale setting (again, see "locale -a") on the Unix platform.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Theodore Petrosky
Date:
Subject: Re: looks like apple fixed /etc/rc
Next
From: Jaime Casanova
Date:
Subject: Re: BUG #1639: Problema re-instalacion