Postgres Pro
Downloads
Home   >   mailing lists

Re: Invalid byte sequence for encoding "UTF8": 0xa1 - when - Mailing list pgsql-odbc

From Hiroshi Inoue
Subject Re: Invalid byte sequence for encoding "UTF8": 0xa1 - when
Date
Msg-id 457F7397.8000404@tpf.co.jp
Whole thread Raw
In response to Invalid byte sequence for encoding "UTF8": 0xa1 - when insert data into bytea.  (bartek@mikronika.com.pl)
Responses Re: Invalid byte sequence for encoding "UTF8": 0xa1 - when
List pgsql-odbc
Tree view 
bartek@mikronika.com.pl wrote:
> Invalid byte sequence for encoding "UTF8": 0xa1 - when insert data into
> bytea.
>
> PostgreSQL: 8.1.5
> Driver: psqlodbc-08.01.0200
> Database in UTF-8.
> Local encoding: LC_ALL=pl_PL.ISO-8859-2
>
> In " convert_to_pgbinary" :
> isalnum(0xa1) return true for pl_PL.ISO-8859-2 but it isn't ascii
> character

Looking at the manual page I found it can be true.

 > and should be convert to octal.

I would take care of it.
Thanks.

regards,
Hiroshi Inoue

pgsql-odbc by date:

Previous
From:
Date:
Subject: [ psqlodbc-Bugs-1000738 ] Wrong ODBC state (42P01 or 42P07) is returned on dropping/creating table
Next
From: Hiroshi Inoue
Date:
Subject: Re: possible odbc driver bug with postgresql-7.4