Im trying to figure out how I can escape special characters in
string constants in my SQL Query.
Is there any utility function I can use to do this? In the lack of this, anyone have any idea of the list of chars that need to be escaped (i know ' and % for instance) and their escape sequences, so that I can write one myself?
I am connecting to an ACCESS DB using Sun's JDBCODBC Bridge.
(BTW, Right now I am somewhat regretting this decision and wishing I had gone w/ ADO instead, because of this and other char encoding issues... Just a little 2 cents)
Best, Tap