Accessing postgresql database

[Jeova Almeida]

Hello,

I have a postgresql database using SQL_ASCII encoding. How can I show the
accentuated characters on a .aspx page?

In web.config file, I tried configuring
<globalization requestEncoding="iso-8859-1" responseEncoding="iso-8859-1"
culture="pt-BR"/>

No avail. I also tried with utf-8.

I used meta tag

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

Not worked too.

I'm using NPGSQL library to access the database, which supports only UNICODE
encoding.

Please help.

 

[Jeova Almeida]

Hello,

I have a postgresql database using SQL_ASCII encoding. How can I show the
accentuated characters on a .aspx page?

In web.config file, I tried configuring
<globalization requestEncoding="iso-8859-1" responseEncoding="iso-8859-1"
culture="pt-BR"/>

No avail. I also tried with utf-8.

I used meta tag

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

Not worked too.

I'm using NPGSQL library to access the database, which supports only
UNICODE encoding.

Please help.

I found a solution: using the built in database function
convert(fiedlName using windows_1250_to_utf8)