Message-Id: <10723.125367@fatcity.com> From: "andrey" Date: Wed, 27 Dec 2000 20:44:48 +0200 Subject: Insert "special characters" This is a multi-part message in MIME format. ------=_NextPart_000_0002_01C07045.DA9B9EA0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Dear DBAs ! I need to insert a string into a VARCHAR2 column . The string contains lots of "special characters" , such as single quotes , slashes , colons , semicolons etc ... For example i need to insert a string such as : "javascript:window.open('http://www.navixo.com/ClientFeedback.asp','ClientFe edback','height=565,width=320');window.stop" The string is dynamic . The RDBMS is Oracle8.1.6 I'm inserting using Perl DBI . Is there a way to do all that ? Thanks a lot in advance for your help ! Andrey . ------=_NextPart_000_0002_01C07045.DA9B9EA0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Dear = DBAs=20 !

I need = to insert a=20 string into a VARCHAR2 column .

The = string contains=20 lots of "special characters" , such as single quotes , slashes , colons = ,=20 semicolons etc ...

For = example i need=20 to insert a string such as :

"javascript:window.open('http://www.navixo.com= /ClientFeedback.asp','ClientFeedback','height=3D565,width=3D320');window.= stop"=20

The = string is=20 dynamic .

The = RDBMS is=20 Oracle8.1.6

I'm = inserting using=20 Perl DBI .

Is = there a way to do=20 all that ?

Thanks = a lot in=20 advance for your help !

Andrey = .