|
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)" 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]
