On Mon, 03 Nov 2003 04:44:38 -0800, Magnus wrote:
Quote:
Is there any way a can 'escape' characters ?
I need to hide a '-sign but I dont know how .
Im using jdbc/CallableStatement and inserting
a lot using batch . 'A lot' is whats preventing
me to use preparedstatments (a limitation of
1000 variables in my setup) . It turned out that
the users expected to use ' in theire data . |
Normally you can escape quotes by doubling them - ie convert
"it's a string" to "it''s a string".
Michael
--
Michael Peppler Data Migrations, Inc.
mpeppler (AT) peppler (DOT) org http://www.mbay.net/~mpeppler
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or
long term contract positions - http://www.mbay.net/~mpeppler/resume.html