Good point, and maybe even better than that would be to
use placeholders.
Mark Vandenbroeck [[EMAIL PROTECTED]] wrote:
> 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
