Thread: possible character accent bug on pgjdbc73
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!
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
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 'ó', 'ó' 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 -- 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
----- Original Message ----- From: "Daniel Serodio" <daniel@checkforte.com.br> To: <shk@linuxbr.com.br> Cc: "PostgreSQL JDBC List" <pgsql-jdbc@postgresql.org> Sent: Wednesday, February 05, 2003 2:00 PM Subject: Re: [JDBC] possible character accent bug on pgjdbc73 You should translate '�' to 'ó', '�' is not valid HTML, despite Internet Exploder rendering it ok. []'s Daniel Serodio ----------------- That is not really the error, because the wrong chars come before the presentation (look the html code i pasted) And pgsql should work correctly with accent-chars, isn't? ----------------- 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 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!
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
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