Unicode Data into a PostgreSQL DB?

[Steve - DND]

I'm currently having some difficulties inserting Unicode text into a
PostgreSQL database from a .Net app. The database is setup with UNICODE
encoding, and .Net apps maintains all strings in a Unicode format so I can't
figure out where the problem is. When I insert regular ASCII text,
everything is just fine. When I try to insert Unicode data, I get the error:
"Invalid UNICODE character sequence found".

However, when I use the exact same INSERT INTO statement in pgAdmin, that I
use in the .Net app, the data is inserted without a problem. I realize most
people here are working with SQL Server or Access, but hopefully someone has
some insight on this.

INSERT INTO dbo."trn_tblCultures" ("Culture", "LCID", "EnglishName",
"NativeName", "LanguageCodeTwoLetter", "LanguageCodeThreeLetter",
"WindowsCodeThreeLetter") VALUES
('ca',3,'Catalan','català','ca','cat','CAT');

Thanks,
Steve

 

[=?ISO-8859-1?Q?Carlos_Guzm=E1n_=C1lvarez?=]

Hello:

I'm currently having some difficulties inserting Unicode text into a
PostgreSQL database from a .Net app.

Can be of help if you tell which data provider are you using for access
PostgreSQL.

 

[Steve - DND]

I'm currently having some difficulties inserting Unicode text into a

Can be of help if you tell which data provider are you using for access
PostgreSQL.

Carlos,
I'm currently using npgsql
http://gborg.postgresql.org/project/npgsql/projdisplay.php

Thanks,
Steve

 

[=?ISO-8859-1?Q?Carlos_Guzm=E1n_=C1lvarez?=]

Hello:

Carlos,
I'm currently using npgsql
http://gborg.postgresql.org/project/npgsql/projdisplay.php

Review this thereat in one of the npgsql mailing lists:

http://gborg.postgresql.org/pipermail/npgsql-general/2003-November/000589.html


Hope this helps.