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,
CONSTRAINT dba_keyclias_sq PRIMARY KEY (dba_keyclias_sq)
Att: It is valid to said that I have also tried the Npgsql dll and got the same error.
pgsql-bugs by date
|Next:||From: Lucas Sultanum||Date: 2004-10-27 20:43:24|
|Subject: 22021: invalid byte sequence for encoding \"UNICODE\": 0xe16d61"|
|Previous:||From: Bruce Momjian||Date: 2004-10-27 18:57:57|
|Subject: Re: Why is abstime type deprecated?|