: [GENERAL] Unicode support problem
"Jatinder Sangha" <[EMAIL PROTECTED]> writes:
> I've setup the postgres database as follows:
> LANG=C
> initdb -E UNICODE
> createdb -E UNICODE
> I have tried setting locale/lc_ctype to C, POSIX, iso_8859_1, all
> kinds
> If I setup the database as follows:
> LANG=C
> initdb -E iso8859_1
> createdb -E iso8859_1
>
> Then it appears to work OK - but I then get an error with character 0xE2
> (Latin small letter a with circumflex):
> ERROR: could not convert UTF-8 character 0x00e2 to ISO8859-1
The error message say
"Jatinder Sangha" <[EMAIL PROTECTED]> writes:
> I've setup the postgres database as follows:
> LANG=C
> initdb -E UNICODE
> createdb -E UNICODE
> I have tried setting locale/lc_ctype to C, POSIX, iso_8859_1, all kinds
> of things, and nothing seems to fix it.
You can't just pick random combinat
Hi all,
I'm having a problem with unicode support in postgres under linux.
The issue is that I am copying lots of data from an MS SQL Server
database via java/jdbc running on Windows XP over to a postgres database
running on linux. I've setup the postgres database as follows:
LANG=C
initdb -E U
