Firebird JDBC driver connection character encoding

Question

I have a JSF application running on tomcat6 in Fedora 17 using firebird as the database and all the registers coming from the database to the application are coming with a encoding problem.

The language is Brazilian portuguese so I need é's and ã's and ç and here all of these special characters come with problems.

The é's and ã's from the original source code are ok, only the ones coming directly from the database are causing me the trouble...

Any idea what is going on?

Heres a image where that weird character should be é

The problem happens when it recovers from the DB.

Answer 1

Using encoding=ISO/UTF/WIN... query parameter in the JDBC connection URL has solved the problem.

For example:

jdbc:firebirdsql:url:db?encoding=ISO8859_1