Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!rip!news.webusenet.com!peer01.cox.net!cox.net!newspeer1-gui.server.ntli.net!ntli.net!news2.euro.net!newsgate.cistron.nl!news.tele.dk!news.tele.dk!small.news.tele.dk!lnewsoutpeer01.lnd.ops.eu.uu.net!lnewsinpeer01.lnd.ops.eu.uu.net!lnewspost00.lnd.ops.eu.uu.net!emea.uu.net!not-for-mail
From: "Niall Litchfield" <niall.litchfield@dial.pipex.com>
Newsgroups: comp.databases.oracle.server
References: <81644a0f.0310090643.b806ecf@posting.google.com>
Subject: Re: oracle replace " ' " with ¿ on a insert statement!!
Date: Fri, 10 Oct 2003 15:37:23 +0100
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
Lines: 19
Message-ID: <3f86c40a$0$270$cc9e4d1f@news.dial.pipex.com>
NNTP-Posting-Host: 1Cust52.tnt103.lnd4.gbr.da.uu.net
X-Trace: 1065796618 news.dial.pipex.com 270 213.116.54.52
X-Complaints-To: abuse@uk.uu.net
Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:245015

Is ' the straightfoward ' mark which is a standard ASCII character or the
windows 'smart quotes' generated by an MS Office program?

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"Michel" <mikechico75@hotmail.com> wrote in message
news:81644a0f.0310090643.b806ecf@posting.google.com...
> When inserting simple string into varchar(4000) oracle change the '
> characters into ¿ ....