JDBC and Latin1 Database problem - Mailing list pgsql-jdbc

Hi all,

  I'm using postgresql 7.4 and pg74.215.jdbc3.jar as jdbc driver.  I got
this error deploying my application on Linux/Tomcat5  This error is not
throwned in my development environment Win2000/Tomcat4.1.

Any Idea?

To inform the jdbc driver that it must converts caracters I put the
following URL in my server.xml (notice the encoding=latin1).  Without this
variable caracter � takes 2 spaces in the latin db.  So ������ will takes 12
spaces.  This make my varchar(10) to small.

jdbc:postgresql://127.0.0.1:5432/webCatalog?encoding=latin1

Is that the way to do it .. because I search a lot an only found a mail
talking about this flag...

Thanks for your help!!

/David


  Error executing: INSERT INTO AK  (AKNUM,AKDESC_PRI,
AKDESC_SEC,AKFRAIS,AKTAUX,AKTYPE) VALUES
('CHEQ','CH?QUE','CHEQUE',22,null,1)
org.postgresql.util.PSQLException: ERROR: could not convert UTF-8 character
0x00ef to ISO8859-1

ERROR [main] (Dao.java:267)  2005-01-04 20:40:10,044 : Error processing the
sql file: resources/auxilary/payment/insert_test.sql
org.postgresql.util.PSQLException: ERROR: could not convert UTF-8 character
0x00ef to ISO8859-1

        at com.ibatis.db.util.ScriptRunner.runScript(ScriptRunner.java:211)
        at com.davecorp.webos.dao.Dao.executeSqlFile(Dao.java:264)
        at com.davecorp.webos.dao.Dao.notificationEvent(Dao.java:234)