Hi!

I have norwegian characters stored in my Firebird database. The
database has the character-set ISO-8859-1. When I try to run a "select
* from table where columnName like '%<norwegian character%' I get the
error message "Cannot transliterate character between characterset".

What is the default character-set of the SQL connection when using
Jaybird? And how do I change it? I am using the built-in pooling of
Tomcat and I am specifying the DB parameters in the
META-INF/context.xml file:

<Context path="/" reloadable="true">
<Resource auth="Container"
driverClassName="org.firebirdsql.jdbc.FBDriver"
maxActive="100" maxIdle="30" maxWait="100"
name="jdbc/DB"
password="xx"
type="javax.sql.DataSource" url="jdbc:firebirdsql:<url>"
username="xx"/>
</Context>

Any help would be very appreciated!

-Christer