Skip site navigation (1) Skip section navigation (2)


From: "Lucas Sultanum" <lucas(dot)sultanum(at)gcf(dot)com(dot)br>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: Bug
Date: 2004-10-27 20:27:20
Message-ID: 001e01c4bc63$5c5476c0$0101a8c0@gcfsistemas (view raw or whole thread)
Lists: pgsql-bugs


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)





Att: It is valid to said that I have also tried the Npgsql dll and got the same error.




Lucas Sultanum

pgsql-bugs by date

Next:From: Lucas SultanumDate: 2004-10-27 20:43:24
Subject: 22021: invalid byte sequence for encoding \"UNICODE\": 0xe16d61"
Previous:From: Bruce MomjianDate: 2004-10-27 18:57:57
Subject: Re: Why is abstime type deprecated?

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group