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.

 

Regards

 

Lucas Sultanum

Outgoing mail is certified Virus Free.
Checked by AVG Anti-Virus (http://www.grisoft.com).
Version: 7.0.269 / Virus Database: 264.12.4 - Release Date: 27/10/2004
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to