Re: Oracle8i International language support question

From: Van Messner <vmessner_at_bestweb.net>
Date: Tue, 19 Sep 2000 00:39:57 GMT
Message-ID: <xByx5.187$VQ.31471@newshog.newsread.com>

Start by checking to see if your database was set up to handle 8-bit characters or only 7-bit US ASCII.

Van

<morris_newsgroup_at_yahoo.com> wrote in message news:8q6acj$puv$1_at_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:39:57 CDT