Subject Re: [Firebird-Java] Cannot transliterate character between characterset, Tomcat
Author Roman Rokytskyy
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".

That is correct :)

> What is the default character-set of the SQL connection when using
> Jaybird?

NONE

> And how do I change it?

Just add it to the URL after the question mark:

jdbc:firebirdsql:myhost/3050:/path/to/db.fdb?encoding=ISO8859_1

Roman