Subject Cannot transliterate character between characterset, Tomcat
Author Christer Nordvik

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"
maxActive="100" maxIdle="30" maxWait="100"
type="javax.sql.DataSource" url="jdbc:firebirdsql:<url>"

Any help would be very appreciated!