Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: why is oracle 8.15 substituting # for £
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