Re: Re: Reading £ character from DB is displaying œ character - Mailing list 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