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

  I would like to know the results too...
  Well, just imagine a site that get thousands of hits/day having all
its output being filtered... seems a lot to me :-)

On Wed, 2003-02-05 at 14:52, Daniel Serodio wrote:
> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
--

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

Centro Universitário Ritter dos Reis
http://www.ritterdosreis.br
ritter@ritterdosreis.br
Fone/Fax.: (51)32303341