charset property is not working

Hi all!

Please help me!

I’m using postgresql 7.3.2 (datasource) and jboss…

When I try to query a table , I get this error:

Invalid character data was found. This is most likely caused by stored data
containing characters that are invalid f

or the character set the database was created in. The most common example
of this is storing 8bit data in a SQL_ASCII database.

That is because in a row I have the character ¥… In the postgresql’s log I
get…

LOG: query: select * from t_migracion_historico where
lower(tps_migrhist_basedato) = 'repuestos' and lower(ts_migrhist_tablorig) =
't_moneda' and (upper(ts_migrhist_procesado)='N' or ts_migrhist_procesado is
null)

LOG: query: select * from t_migracion_historico;

LOG: query: set datestyle to 'ISO'; select version(), case when
pg_encoding_to_char(1) = 'SQL_ASCII' then 'UNKNOWN' else
getdatabaseencoding() end;

LOG: query: ÿþs

ERROR: parser: parse error at or near "ÿþs" at character 1

FATAL: Socket command type e unknown

So, I try to set the connection property in the datasource descriptor:

<connection-property name="charSet">UNICODE</connection-property>

Because I set client_encoding to UNICODE in postgresql.config.

But when I try to run the application again, it throws

Could not create connection; - nested throwable: (Something unusual has
occured to cause the driver to fail. Please report this exception:
Exception: java.sql.SQLException:

Stack Trace:

java.sql.SQLException:

at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:131)

at
org.postgresql.jdbc1.AbstractJdbc1Connection.ExecSQL(AbstractJdbc1Connection
.java:482)

at
org.postgresql.jdbc1.AbstractJdbc1Connection.ExecSQL(AbstractJdbc1Connection
.java:461)

at
org.postgresql.jdbc1.AbstractJdbc1Connection.openConnection(AbstractJdbc1Con
nection.java:376)

at org.postgresql.Driver.connect(Driver.java:122)

at
org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createMa
nagedConnection(LocalManagedConnectionFactory.java:150)

at
org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createCon
nectionEventListener(InternalManagedConnectionPool.java:477)

...

Could anybody help to me? What is the right way to do this query?

Thanks in advance!

Katalina