Barry,
Besides the improved message issue, I tried with a database with the
default locale (C), but I also tried to restore the database to the
cluster with portuguese locale (pt_PT) (initdb --locale=pt_PT
--lc-colate=pt_PT --lc-ctype=pt_PT --lc-message=pt_PT), and I still have
the same error in JDBC (not the improved message, but the error).
What configurations should I have to support portuguese locale in my
database/JDBC?
thanks,
Pedro Salazar.
On Fri, 2003-04-11 at 16:46, Barry Lind wrote:
> Pedro,
>
> If you were running the latest build from http://jdbc.postgresql.org you
> would see the following improved error message:
>
> Invalid character data was found. This is most likely caused by stored
> data containing characters that are invalid for the character set the
> database was created in. The most common example of this is storing
> 8bit data in a SQL_ASCII database.
>
> thanks,
> --Barry
>
>
> Pedro Salazar wrote:
> > Hi,
> >
> > I forgot to tell that I'm using the JDBC driver build from postgresql
> > 7.3.2.
> >
> > PS
> >
> > On Fri, 2003-04-11 at 11:19, Pedro Salazar wrote:
> >
> >>Greetings,
> >>
> >>I have function that returns a refcursor. When I call it in plpgsql
> >>shell, it returns all the rows correctly. But, When I call it in JDBC,
> >>when it tries to decode a string in specific row (7) it throws the
> >>following exception:
> >>
> >>java.lang.ArrayIndexOutOfBoundsException: 5
> >> at org.postgresql.core.Encoding.decodeUTF8(Encoding.java:254)
> >> at org.postgresql.core.Encoding.decode(Encoding.java:165)
> >> at org.postgresql.core.Encoding.decode(Encoding.java:181)
> >> at
> >>org.postgresql.jdbc1.AbstractJdbc1ResultSet.getString(AbstractJdbc1ResultSet.java:97)
> >>
> >>My refcursor returns the following list (the characters are in
> >>portuguese language):
> >>
> >> id | class
> >>----+-------------
> >> 1 | Avenida
> >> 2 | Bairro
> >> 3 | Cais
> >> 4 | Estrada
> >> 5 | Largo
> >> 6 | Lugar
> >> 7 | Praça
> >> 8 | Rotunda
> >> 9 | Rua
> >> 10 | Sítio
> >> 11 | Travessa
> >> 12 | Urbanização
> >>
> >>The row number 7 (Praça) [character 'C' with cedilla] is throwing the
> >>above exception. How should I retrieve my string which has portuguese
> >>characters, in JDBC?
> >>
> >>thanks,
> >>Pedro Salazar.
--
PS
pedro-b-salazar@ptinovacao.pt
PGP:0E129E31D803BC61
