Re: Re: Reading £ character from DB is displaying œ character

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Re: Reading £ character from DB is displaying œ character
Date: 2013-09-23 23:02:39
Message-ID: 5240C88F.4020006@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

On 9/23/2013 1:58 PM, saisantoshi wrote:
> Here is the exact error when trying to set to UT8 and updating £ character.
>
> ERROR: invalid byte sequence for encoding "UTF8": 0x9c

WIn1252 is a Windows-specific variant of LATIN-1, an 8 bit character set.

0x9C is in fact the oe munged character in Win1252, and is an invalid
character encoding in UTF8.

the UK pound symbol is 0xA3 in Win1252, and in UTF8, a UK pound sign
is: C2 A3, which is U+00A3 in UTF16/UCS2.

Win1252 code table:
http://en.wikipedia.org/wiki/Windows-1252#Code_page_layout

partial UTF8 char table:
http://www.utf8-chartable.de/

ahhhh. 0x9C is the pound symbol in CP437, the MSDOS CGA/EGA/VGA
text-mode font.

--
john r pierce 37N 122W
somewhere on the middle of the left coast

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message saisantoshi 2013-09-24 00:27:37 Re: Reading £ character from DB is displaying œ character
Previous Message saisantoshi 2013-09-23 20:58:56 Re: Reading £ character from DB is displaying œ character