From: | "Lucas Sultanum" <lucas(dot)sultanum(at)gcf(dot)com(dot)br> |
---|---|
To: | <pgsql-odbc(at)postgresql(dot)org> |
Subject: | 22021: invalid byte sequence for encoding \"UNICODE\": 0xe16d61" |
Date: | 2004-10-27 20:46:50 |
Message-ID: | 003501c4bc66$156b82f0$0101a8c0@gcfsistemas |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Hello,
I am not sure if this is a bug or I am doing something wrong. When I execute the following command (insert into a_cadclias values ('6542','65465','amaro','ámaro')) on pgAdmin III Query it works pretty well, but when I try to do the same through a C# App connecting to the database through an ODBC driver I get the following error:
"ERROR: 22021: invalid byte sequence for encoding \"UNICODE\": 0xe16d61"
I know that it has something to do with the word ámaro because when I take the letter á off and replace it with the letter a it works fine.
Bellow goes the table structure:
CREATE TABLE a_cadclias
(
dba_clias_cliente "numeric"(8) NOT NULL,
dba_clias_associado "numeric"(8) NOT NULL,
dba_keyclias_sq "varchar"(8) NOT NULL,
teste "varchar"(10),
CONSTRAINT dba_keyclias_sq PRIMARY KEY (dba_keyclias_sq)
)
WITH OIDS;
Att: It is valid to said that I have also tried the Npgsql dll and got the same error.
Versions tested:
"PostgreSQL 8.0.0beta2 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.2.3 (mingw special 20030504-1)"
AND
"PostgreSQL 8.0.0beta4 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.3.1 (mingw special 20030804-1)"
Regards
Lucas Sultanum
Attachment | Content-Type | Size |
---|---|---|
unknown_filename | text/plain | 162 bytes |
From | Date | Subject | |
---|---|---|---|
Next Message | Jose Landaeta | 2004-10-28 12:07:01 | Re: UNSUBSCRIBE |
Previous Message | Jeff Eckermann | 2004-10-27 17:20:58 | Re: update rules + views + odbc problems |