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: why is oracle 8.15 substituting # for £

Re: why is oracle 8.15 substituting # for £

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Tue, 12 Mar 2002 20:45:35 +0000
Message-ID: <3C8E68EF.6ECF@yahoo.com>


zdy wrote:
>
> Hi,
> I'm new to oracle and have just working with a big existing DB with no
> documentation. When text is entered into the database, through ADO &
> ODBC or through the SQL interface in Toad, £ symbols are replaced with
> #. There are no triggers on this table and the data type is Varchar2.
> I'm able to work around the problem by using replace functions at the
> middle tier, but I would really like to know why this is happening.
> Thanks,
> Zdy

I think the hash is the first 7bits of the (8bit) pound sign.

Things like 'stty istrip' on unix, or profile entries for language can alter this.

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."
Received on Tue Mar 12 2002 - 14:45:35 CST

Original text of this message

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