Обсуждение: RecordSets, getString and charSets

Hello,

I have a problem with recordsets and charsets.

I have inserted some data into a postgresql database including spanish
characters. When I execute pgsql and I run some select queries, I get
the data in the right way, with the spanish characters I inserted.

But when I execute the same queries from a Java program using a JDBC
connection, I obtain different (non-spanish) characters after calling
the getString method to get the data from the recordSet.

I have tried different ways of getting the data from the recordSet, such
as inserting the data into a stream (calling the getAsciiStream,
getUnicodeStream and getBinaryStream methods) and converting the data
into bite[] and then to String, but the same happens.

Does anybody knows what can I do to solve this problem?

Thanks and regards,
Rosa M. Carro