[sqr-users] Re: Single quote issue

[David Donnelly <Dave@isisbio.com>]

When I have this problem, I use a translate on all the input strings to 
translate the quote character ($27) to the reverse quote character 
($B4).  They look nearly the same, but Oracle doesn't recognize the latter 
as a quote. You'll also have to do it to data accepted for update before it 
goes into the database.

This requires that you are using an appropriate 8-bit ASCII character set 
in the database, which most Oracle users do. This may not work if you have 
a character set for supporting an accented language; the B4 slot maybe used 
for something else.

encode <180> into $revquote
let $newstring = translate($original,'''',$revquote)



_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users