Subject Re: [Firebird-Java] Cannot transliterate character between characterset, Tomcat
Author Allysson Costa
You need put the expression at end of string (url) of connection:


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


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

Any help would be very appreciated!


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

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