Insert "special characters"

From: andrey <bronfin_at_visualtop.com>
Date: Wed, 27 Dec 2000 20:44:48 +0200
Message-Id: <10723.125367@fatcity.com>

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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2920.0" name=3DGENERATOR></HEAD>
<BODY>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D933393618-27122000>Dear =
DBAs=20
!</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D933393618-27122000></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D933393618-27122000>I need =
to insert a=20
string into a VARCHAR2 column .</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D933393618-27122000>The =
string contains=20
lots of "special characters" , such as single quotes , slashes , colons = ,=20
semicolons etc ... </SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D933393618-27122000>For =
example i need=20
to insert a string such as : </SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D933393618-27122000>"javascript:window.open('http://www.navixo.com= /ClientFeedback.asp','ClientFeedback','height=3D565,width=3D320');window.= stop"=20
</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D933393618-27122000></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D933393618-27122000>The =
string is=20
dynamic .</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D933393618-27122000></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D933393618-27122000>The =
RDBMS is=20
 Oracle8.1.6 </SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D933393618-27122000>I'm =
inserting using=20
Perl DBI .</SPAN></FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D933393618-27122000>Is =
there a way to do=20
all that ?</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D933393618-27122000></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D933393618-27122000>Thanks =
a lot in=20
advance for your help !</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D933393618-27122000></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D933393618-27122000></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D933393618-27122000>Andrey =

.</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D933393618-27122000></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D933393618-27122000></SPAN></FONT> </DIV></BODY></HTML> Received on Wed Dec 27 2000 - 12:44:48 CST