The more generic solution would be to use DBI's quote function : eg.
my $st = $db->prepare("insert into Tname values(".
$db->quote("Gopi's") . ", '20')");
Hope this helps,
Mark
Hardy Merrill wrote:
> I think I remember that to escape a single quote so that you
> can include it in a string, you need to escape a single quote
> with a single quote, like this:
>
> inset into Tname values('Gopi''s','20');
>
> HTH.
>
> --
> Hardy Merrill
> Mission Critical Linux, Inc.
> http://www.missioncriticallinux.com
>
> gopinath r [[EMAIL PROTECTED]] wrote:
> > Hai
> >
> > my problem is to insert a varchar2 datatype which
> > contains single quote(') into Oracle table from Perl.
> >
> > i am using ActivePerl for windows...how to handle this
> > problem.
> >
> > eg. inset into Tname values('Gopi's','20');
> > ------
> >
> > Thanks
> > gopi
> >
> >
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Make a great connection at Yahoo! Personals.
> > http://personals.yahoo.com
