Skip to Main Content

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Encoding problem with Firebird on Linux

843859Mar 30 2009 — edited Apr 2 2009
I've an application that run on Win and Linux (CentOS). This is my situation :

Tomcat 6, Firebird 2 ( DB encoding set to : NONE ), Locale on Linux : UTF8

This is the xml setting connection, that works fine (**** mean data hided) :
<Resource name="jdbc/****Interbase" auth="Container" localDataSource="true"
type="javax.sql.DataSource" maxActive="30" maxIdle="30" maxWait="10000" 
username="****" 
password="****"
driverClassName="org.firebirdsql.jdbc.FBDriver"
url="jdbc:firebirdsql:****.fdb"
removeAbandoned="true" removeAbandonedTimeout="600"/>
On Linux I see Euro sign and accent signs correctly on my broswer, but if I do this query on my Firebird DB :
SELECT FIELD FROM TABLE
I get weird characters. I have this problem only in Linux.

I have to set some properties on my setting connection? ('charSet', 'lc_ctype', 'encoding')

Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 30 2009
Added on Mar 30 2009
2 comments
762 views