Re: possible character accent bug on pgjdbc73 - Mailing list pgsql-jdbc

On Wed, 2003-02-05 at 14:13, Felipe Schnack wrote:
>   Nope... this is normally a combination of pagecode problems. You must
> assure you have created you database using LATIN1 charset (create db -E
> LATIN1 databasename) and that the client support it also... anyway, I
> guess is too much of an overkill to filter all strings sent to output to
> its html tags
>   You may also check you JVM charset

I stand corrected. My knowledge on the subject it a little outdated. I
went to w3.org to check things, and now my suggestion is that you
include the following line in the HEAD section of your HTML:

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

...or the following line in the Headers of your HTTP response:

Content-Type: text/html; charset=ISO-8859-1

See if that solves the problem. Please post the results on the list, or
to me personally, as I'm interested in this information.

BTW, filtering HTML is not overkill! What would you do if it were '<'
instead of 'ó'? You'd be required to filter it!

[]'s
Daniel Serodio

> On Wed, 2003-02-05 at 14:00, Daniel Serodio wrote:
> > You should translate 'ó' to 'ó', 'ó' is not valid HTML, despite
> > Internet Exploder rendering it ok.
> >
> > []'s
> > Daniel Serodio
> >
> > On Sun, 2003-01-05 at 10:51, shk@linuxbr.com.br wrote:
> > > I think there is a bug on postgresql 7.3 jdbc
> > >
> > > I have a intranet that runs on postgresql 7.1 and (resin as container
> > > and red hat 7.2 linux) working well
> > > So, i tried to upgrade to postgresql 7.3.1
> > > The export done OK, but when i started to test the pages, i got some
> > > weired results.
> > >
> > > There is a example:
> > > on psql:
> > > intraprime=# select nome from setores where codigo=5;
> > >    nome
> > > ----------
> > >  Custódia
> > > (1 row)
> > >
> > >
> > > but on a jsp page, i got that result:
> > > <option value='5'>Custýdia</option>
> > >
> > > It seems that every accent character is changed to 'ý'.
> > > I've tryed all versions os pgjdbc73 and the development drivers. I
> > > tryed too the pgsqljdbc72 driver, but no sucess.
> > >
> > > I hope some reply! :)
> > > Thanks very much!
> > >
> > >
> > > Icon - Internet grátis, e-mail, MP3 player, vídeo, rádio e muito mais.
> > > Pegue já o seu em  http://www.ibest.com.br/icon/mbr1.html. É grátis!
> > >
> > > ---------------------------(end of broadcast)---------------------------
> > > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
> > --
> > Daniel Serodio <daniel@checkforte.com.br>
> > CheckForte
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 5: Have you checked our extensive FAQ?
> >
> > http://www.postgresql.org/users-lounge/docs/faq.html
--
Daniel Serodio <daniel@checkforte.com.br>
CheckForte