From: Jeroen T. Vermeulen <jtv@xs4all.nl>
To: Korumilli, Bala S (GE Healthcare) <Bala.Korumilli@ge.com>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: Problem with character encodings.
Date: Thu, 30 Aug 2007 22:39:25 +0700 (ICT)
Message-ID: <9054.125.24.219.40.1188488365.squirrel@webmail.xs4all.nl> (raw)
In-Reply-To: <BF8B7E5C1F593446B8C0AD412C265ED7014BECAA@BANMLVEM04.e2k.ad.ge.com>
References: <BF8B7E5C1F593446B8C0AD412C265ED7014BECAA@BANMLVEM04.e2k.ad.ge.com>
On Thu, August 30, 2007 16:29, Korumilli, Bala S (GE Healthcare) wrote:
> I also tried inserting the character using its CODE. Characters 176, 186
> for code page 1252. And character 248 for code page 437 .
> And I also tried all the characters from 128 to 255. For all these
> characters, Postgres is giving the same error.
So you also tried sending raw byte values for the UTF-8 character? For
codepoint 176, I think that would be 0xc2 (194) followed by 0xb0 (176, by
pure coincidence).
If that failed as well then it sounds as if the database was not set up as
a Unicode one after all. That's where it get system-specific and I
probably can't help you with it, but it sounds as if your database may
have been set up for ASCII.
> Can you please eloborate on this I could not understand this sentence.
> "The database doesn't expose its encoding IIRC, only its character set.
> So it's possible that that should be Unicode, not UTF-8."
It's only a small point, but IIRC the "encoding" given for a postgres
database set up to support Unicode is normally "Unicode," not "UTF-8."
Jeroen
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: jtv@xs4all.nl, Bala.Korumilli@ge.com
Subject: Re: Problem with character encodings.
In-Reply-To: <9054.125.24.219.40.1188488365.squirrel@webmail.xs4all.nl>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox