You need put the expression at end of string (url) of connection:

jdbc:firebirdsql:localhost:/path_to_database/database.fdb?lc_type=ISO8859-1

I can´t remmember all possibilites for lc_type but you can try with: ISO8859-1 or ISO8859_1.



Allysson
Brazil



Christer Nordvik <cnordvik@...> escreveu: 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






---------------------------------
Novo Yahoo! Cadê? - Experimente uma nova busca.

[Non-text portions of this message have been removed]