Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Euro sign not displayed properly when fetched from DB

Re: Euro sign not displayed properly when fetched from DB

From: Raga <raaga.t_at_gmail.com>
Date: 8 Oct 2006 00:12:43 -0700
Message-ID: <1160291563.878132.105350@i3g2000cwc.googlegroups.com>


sorry abt the duplicate posting. Posted by mistake.

Raga wrote:
> 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 Sun Oct 08 2006 - 02:12:43 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US