Thread: encoding...

encoding...

From
Felipe Schnack
Date:
  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??

--

Felipe Schnack
Analista de Sistemas
felipes@ritterdosreis.br
Cel.: (51)91287530
Linux Counter #281893

Faculdade Ritter dos Reis
www.ritterdosreis.br
felipes@ritterdosreis.br
Fone/Fax.: (51)32303328


Re: encoding...

From
Steve Crawford
Date:
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 ™ 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??