Unicode, InterBase and Jboss 2.4.6 problem.

[noir]

I have a Jboss 2.4.6 connected to InterBase/Firebird 1.0 by InterClient 2.0 on Win2000. The database has Blob field with some Unicode data in it.

Everything is fine but when I restart Jboss, redeploy bean or simply leave server for 10 or so minutes doing nothing all Unicode data are trashed like this: ?©?????°.

The part of jboss.jcml where DB connection is configured:

 <mbean code="org.jboss.jdbc.XADataSourceLoader" name="DefaultDomain:service=XADataSource,name=DefaultDS">
 <attribute name="PoolName">DefaultDS</attribute>
 <attribute name="DataSourceClass">org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl</attribute>
 <attribute name="URL">jdbc:interbase://localhost/D:/firebird/devel/ptts01.gdb</attribute>
 <attribute name="Properties">user=nomatter;password=nomatter";charSet=UTF8</attribute>
 </mbean>

[noir]

Sorry, in the previous post I tried to show trashed unicode but it was converted to question marks. There were just incomprehensible mess, not question marks. (I solved question marks problem yesterday :)

[noir]

looks like I've solved the problem by setting blob subtype to 1(text) and retrieving result with ResultSet.getString() in ejbLoad().