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_at_nnrp1.deja.com>
Date: Tue, 19 Sep 2000 00:01:34 GMT
Message-ID: <8q6acj$puv$1_at_nnrp1.deja.com>
[Quoted] 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 Tue Sep 19 2000 - 02:01:34 CEST