Hi,
this is not a DbForms related topic, but it could be useful...
If you use Postgresql 7.2 as rdbms and you have some databases with
"SQL_ASCII" encoding (psql -l),
you can handle accented characters (�, �, etc) with the provided JDBC
driver (http://jdbc.postgresql.org) with the following settings:
driver: org.postgresql.Driver
url: jdbc:postgresql://myHost/myDatabase?charSet=ISO-8859-1
(note that "charSet=UTF-8" doesn't work for my db settings... )
or you can set the charSet with this code (hint by Dirk Kraemer):
/*
* Establish and return a connection to the database.
*/
private Connection getConnection() throws SQLException,
ClassNotFoundException
{
String myCharSet = "ISO-8859-1";
Class.forName("org.postgresql.Driver");
Properties info = new Properties();
info.put("user", user);
info.put("password", password);
info.put("charSet", myCharSet);
return DriverManager.getConnection(url, info);
}
Luca
-------------------------------------------------------
Sponsored by:
ThinkGeek at http://www.ThinkGeek.com/
_______________________________________________
DbForms Mailing List
http://www.wap-force.net/dbforms
