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.