Re: encoding...

From: Steve Crawford <scrawford(at)pinpointresearch(dot)com>
To: Felipe Schnack <felipes(at)ritterdosreis(dot)br>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: encoding...
Date: 2002-11-25 19:17:25
Message-ID: 20021125191725.942C7103C2@polaris.pinpointresearch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Assuming you mean a web browser, view the source code of the html page as a
first shot. Most browsers will put a ? in place of a character that they
can't render (hence the ugly look of many pages created with Microsoft tools
which tend to put in things like left and right quotes and trademark
characters instead of the correct &trade; or other character codes). Make
sure that you are specifying the correct character set in your html page,
that your browser understands the characters you are feeding it (actually,
make sure you are using the correct &<symbol>; for the character you want to
display) and that your selected typeface has the character available before
suspecting the database. You may want to do the same query with psql and
other tools to see what is returned.

Cheers,
Steve

On Monday 25 November 2002 10:51 am, Felipe Schnack wrote:
> I have a pgsql database created using default (zero) encoding. I'm
> developing an application using Tomcat 4.1...
> If I connect to my database using psql, I insert data normally, using
> portuguese accents and they look ok when I do "select * from <table>".
> Why I see only "?" signs where I should find accents in the client
> browser??

In response to

  • encoding... at 2002-11-25 18:51:19 from Felipe Schnack

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Sacksteder 2002-11-25 20:11:10 null date comparison
Previous Message Felipe Schnack 2002-11-25 18:51:19 encoding...