Euro sign not displayed properly when fetched from DB
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.
