Thread: Invalid byte sequence for encoding "UTF8": 0xa1 - when insert data into bytea.

Invalid byte sequence for encoding "UTF8": 0xa1 - when insert data into bytea.

From
bartek@mikronika.com.pl
Date:
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 and should be convert to octal.

Solution:
======================diff_file=================================
--- oryg/convert.c      2006-01-08 11:09:52.000000000 +0100
+++ popr/convert.c      2006-12-05 11:24: 20.000000000 +0100
@@ -3709,6 +3709,15 @@
 }


+BOOL myisalnum(UCHAR c)
+{
+    if(isalnum(c) && c <128)
+    return TRUE;
+
+    return FALSE;
+}
+
+
 /*     convert non-ascii bytes to octal escape sequences */
 int
 convert_to_pgbinary(const UCHAR *in, char *out, int len)
@@ -3719,7 +3728,7 @@
        for (i = 0; i < len; i++)
        {
                mylog("convert_to_pgbinary: in[%d] = %d, %c\n", i, in[i],
in[i]);
-               if (isalnum(in[i]) || in[i] == ' ')
+               if (myisalnum(in[i]) || in[i] == ' ')
                        out[o++] = in[i];
                else
                {
=========================================================




Re: Invalid byte sequence for encoding "UTF8": 0xa1 - when

From
Hiroshi Inoue
Date:
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

Re: Invalid byte sequence for encoding "UTF8": 0xa1 - when

From
Hiroshi Inoue
Date:
Hiroshi Inoue wrote:
> 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.

Please try the snapshot dll at
   http://www.geocities.jp/inocchichichi/psqlodbc/index.html
.

regards,
Hiroshi Inoue