Re: possible character accent bug on pgjdbc73

From: Felipe Schnack <felipes(at)ritterdosreis(dot)br>
To: pgsql-jdbc <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: possible character accent bug on pgjdbc73
Date: 2003-02-05 16:13:00
Message-ID: 1044461580.9222.79.camel@desenv1.ritterdosreis.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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

On Wed, 2003-02-05 at 14:00, Daniel Serodio wrote:
> You should translate 'ó' to '&oacute;', 'ó' is not valid HTML, despite
> Internet Exploder rendering it ok.
>
> []'s
> Daniel Serodio
>
> On Sun, 2003-01-05 at 10:51, shk(at)linuxbr(dot)com(dot)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(at)postgresql(dot)org
> --
> Daniel Serodio <daniel(at)checkforte(dot)com(dot)br>
> CheckForte
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
--

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

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

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Andy Kriger 2003-02-05 16:17:15 Re: Netbeans - JDBC Driver Class
Previous Message Daniel Serodio 2003-02-05 16:00:59 Re: possible character accent bug on pgjdbc73