Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Asp.net and Postgresql

Posted on 2009-05-15
8
Medium Priority
?
749 Views
Last Modified: 2013-11-08
I have an asp.net 3.5 app using a postgresql database with sql_ascii encoding.  How do I configure my app to show strings with accentuation from DB?

After searching for a solution, I found that the encoding used by postgresql is always unicode (connection string = Server={0}; Port={1}; database={2}; Userid={3}; password={4}; Pooling=false; Timeout=20; Encoding=UNICODE",). If you use ASCII, it's ignored.

At the head section of my aspx page, I tried using
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

I inserted
    <globalization requestEncoding="iso-8859-1" responseEncoding="iso-8859-1" culture="pt-BR"/>
at my web.config file. I also tried
    <globalization requestEncoding="utf-8" responseEncoding="utf-8" culture="pt-BR"/>

None of this solved my problem. the accentuated character are shown as square characters.
0
Comment
Question by:jeovaalmeida
  • 4
  • 4
8 Comments
 
LVL 62

Expert Comment

by:gheist
ID: 24403294
And what is symbol under square character?
Do you use custom font without sheriff / sans sheriff fallback?
Does this show up correctly :http://en.wikipedia.org/wiki/Portuguese_alphabet ?
0
 

Author Comment

by:jeovaalmeida
ID: 24411424
The characters shown as square (as big as lowercase characters) are those accentuated characters, at http://en.wikipedia.org/wiki/Portuguese_alphabet, at the line (3rd) that starts with "In addition, the following characters with diacritics are used " ...
The font used by my website is tahoma.
 >> Does this show up correctly :http://en.wikipedia.org/wiki/Portuguese_alphabet ?
I'm not sure if I understood your question correcty, but if you want to know if the characters of that page shows up correctly, the answer is yes.
0
 
LVL 62

Expert Comment

by:gheist
ID: 24411844
You have to install support for your region from windows to get characters displayed correctly in all fonts.
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:jeovaalmeida
ID: 24411964
And how do I do that?
0
 
LVL 62

Expert Comment

by:gheist
ID: 24412004
CYou can have look at page source in your browser - do you get correct characters and encodings from server. Sometimes it is wrong server encoding header you never paid attention to.
0
 

Author Comment

by:jeovaalmeida
ID: 24413009
I clicked View >> Source Code. The HTML shows the squares, too.
Firefox has the "iso-8859-1" as an option for encoding option (View >> Encoding) . But even selecting this option the right characters aren't shown. (though the square character is changed by other strange one).
0
 
LVL 62

Expert Comment

by:gheist
ID: 24419387
So ASPnet gives squares.
0
 

Accepted Solution

by:
jeovaalmeida earned 0 total points
ID: 24435306
I found a solution: using the built in postgre database function
convert(fiedlName using windows_1250_to_utf8)
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
Steps to create a PostgreSQL RDS instance in the Amazon cloud. We will cover some of the default settings and show how to connect to the instance once it is up and running.
Loops Section Overview
Suggested Courses

571 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question