I'm using SDK 1.4.2_03 either with an Oracle 9.2 or an Oracle 9.2.0.4
client version.
The 9.2 version behaves as expected.
My problem only occurs with the 9.2.0.4. version.
If I try to process the ResultSet of database query and the selected
column data includes leading blanks, the 9.2.0.4 seems to trim these
leading blanks.
Is this behaviour known or am I doing something wrong ?
<code snippet>
ResultSet result = null;
Connection con = null;
Statement stmt = null;
Vector vec = new Vector();
try {
con = DriverManager.getConnection(dbUrl, dbUser, dbPassword);
stmt = con.createStatement();
result = stmt.executeQuery("SELECT DATA FROM
CPTMESSAGEDATA";);
while (result.next()) {
vec.add(result.getString("DATA"));
}
con.close();
stmt.close();
} catch (SQLException e) {
}
</code snippet>
CPTMessageData.DATA is of type VARCHAR2(50) not nullable with values
like:
" @20013 @E123 @G123 @ @ @ "
" @3700167 @43186 @B50_300 @1 @20013 @1 @OK
"
Any help is appreciated.
Alex