Vitali Lovich wrote:
I have a statement along the lines of:
"SELECT * FROM table WHERE value LIKE :abc"
I want to bind a UTF-16 string to abc - however, it can potentially
contain % or _ - does sqlite provide any functionality for escaping
these characters (I know I have to use the escape clause, but I still
have to escape the individual characters in the string replacing :abc)
or do I have to write my own routine that works with the wider string?
Vitali,
No, there is no API in sqlite to escape the wildcard and escape
characters in a LIKE search string. You will have to do it yourself.
HTH
Dennis Cote
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
