Bug in PGSQL 9.0 with handling chr(1..255) in Win1250 context?

From: Durumdara <durumdara(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Bug in PGSQL 9.0 with handling chr(1..255) in Win1250 context?
Date: 2011-04-14 08:38:06
Message-ID: BANLkTik7pqiCngeVV5-hVHe+aZqemX-n+w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi!

Windows 7x64, PG9.0, PGAdmin 1.12.1.

First I sent this problem to PGADMIN support list, you can see it, but
I repeat the description.

http://archives.postgresql.org/pgadmin-support/2011-04/msg00012.php

I tried to fillup a text field with all ANSI characters
chr(1)..chr(255). Except 0 because it is string limitator in C.

This experience is based on that I want to check, how the row encoded
in "Backup" (how to COPY eat this).

But when I tried to see the row in PGADMIN, I got this error:

ERROR: character 0x81 of encoding "WIN1250" has no equivalent in "UTF8"

********** Error **********

ERROR: character 0x81 of encoding "WIN1250" has no equivalent in "UTF8"
SQL state: 22P05

I reported this to PGADMIN list, but Dave said:

That error comes from PostgreSQL, and is entirely expected if you try
to store non-printable characters in a text column, and then convert
it to UTF-8 (which is what happens when pgAdmin requests data).
PostgreSQL is extremely strict about enforcing the correctness of
unicode data.

Interesting thing that I have Win1250 context with Win1250 db.

I think that is unacceptable to cannot see the row.

EMS PG Manager can show the row, but may it do something in other way
- I don't know.

Thanks:
dd

Browse pgsql-general by date

  From Date Subject
Next Message Lonni J Friedman 2011-04-14 08:44:15 Re: updating rows which have a common value forconsecutive dates
Previous Message Henry C. 2011-04-14 08:35:03 Re: SSDs with Postgresql?