Hi Folks,
firebird 1.02, Sun JDK1.3.1, Interclient 1.6, FirebirdSQL RC 3

We have a dialect 1 test DB with 1 table, 1 column and 2 records.
The column is defined as blob subtype 1 charset NONE. The database
charset is NONE.

Everything works fine on windows and Mandrake 8 and 9. However we
tried to install our app on a redhat 8 box.

With the following test program:

import java.sql.*;

public class JDBCTest {

public JDBCTest() {
}
public static void main(String[] args) {
try {
Class.forName("org.firebirdsql.jdbc.FBDriver");
Connection con = DriverManager.getConnection
("jdbc:firebirdsql://localhost/c:/blobtest.fdb","SYSDBA","masterkey")
;
ResultSet rs = con.createStatement().executeQuery("select *
from test");
String r;
while (rs.next()) {
r = rs.getString(1);
System.err.println(r + " [" + r.length() + "]");
}
} catch (Exception e) {
e.printStackTrace();
}
}
}

We get the following (expected) results on Windows and Mandrake.

Aktiv ™ [7]
My Prod ™ Product Overview [27]

On redhat we get

Aktiv [6]
My Prod [8]

If we repeat the test using interclient (1.6) we get the following

Aktiv ™ [7]
My Prod ™ Product Overview [27]

On redhat we get

Aktiv  [7]
My Prod  Product Overview [27]

Can anyone shed any light on these differences? I've posted the
database in the files section.