Hi,

I stored the euro sign (€ ) (press alt+0 1 2 8 on Windows to get that
sign) in an Oracle database table in varchar2 type column. when I do
'select * from table_euro;', I get the euro sign displayed properly in
SQL prompt.

SQL> select * from table_euro
2 /

NAME
--------------------
€



Now, I programatically read it using Java Resultset object, but it
displays as Ç (which is Alt + 1 2 8 in key press). This' how I fetch
it programmatically:

dbStatement = dbCon.createStatement(ResultSet.TYPE_FORWARD_ONLY,
ResultSet.CONCUR_READ_ONLY);
dbDataReader = dbStatement.executeQuery(query);
.....
while(until result set is read fully)
{
Object fieldData = dbDataReader.getObject(fieldIndex);
System.out.println(fieldData);
}


For the euro sign, the above prints Ç . Why is that? Can anyone please
throw some light on it?


Thanks.