Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> 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. Received on Sat Oct 07 2006 - 09:45:03 CDT
![]() |
![]() |