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 -> Oracle8i International language support question

Oracle8i International language support question

From: <morris_newsgroup_at_yahoo.com>
Date: Tue, 19 Sep 2000 00:01:34 GMT
Message-ID: <8q6acj$puv$1@nnrp1.deja.com>

Our application will need to support US and British Pound. If we store £ (the british pound sign) in oracle8i in a varchar2 field, it returns a # instead of £. We found that we could get around this by altering the session before we do the select on that varchar2 field. But I just wonder if we can have this capability database-wide for all sessions so that no alter session is needed. So when we have $, it will return $. If we have £, it should return £. The database can have these two currency symbols at the same time.

Does anyone know how to fix this problem?

Thanks in advance,
Morris

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Sep 18 2000 - 19:01:34 CDT

Original text of this message

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