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

Bug

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 flat)
Thread:
Lists: pgsql-bugs
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

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-2014 The PostgreSQL Global Development Group