What is the difference between sqlite_udf_encode_binary and sqlite_escape_string ?
Is sqlite_escape_string the same as sqlite_udf_encode_binary, except that sqlite_escape_string is also doubling up single-quote characters (') ?
Is this because a User Defined Function (UDF) automatically doubles up single-quote characters in the case of a INSERT statement and so sqlite_escape_string can't be used in combination with a UDF? (The use of sqlite_escape_string on strings returned from UDF's will lead to double-quoting of the data?)
I also have another, related question: Suppose I have a string of which I know it doesn't contain binary-unsafe characters, but does contain single-quote characters. If I escape this string with sqlite_escape_string and INSERT this string in the database, do I have to decode the data with sqlite_udf_decode_binary when I SELECT this data from the database?
Thanks in advance for the answers.
______________________________________________________________
Gratis e-mail en meer: http://www.dolfijn.nl/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
