0
(click on this box to dismiss)
How do I escape strings in PHP to pass binary data to a table via an insert or update statement ?
This is on the back of my previous question, it would be important for Cubrid to have a similar function to mysql_escape_string for passing of binary information to an SQL statement.
How should I do this in the interim, I have already done the normal replace single quotes with double single quotes.
link
comment (3)
asked last year
26
If the following answer answers your question, please accept it. Otherwise, let us know more in the comments. - ![[Level:8]](http://www.cubrid.org/modules/point/icons/default/8.gif "Rank: 8/30, reputation score 558 (28% completed for the next level)")
CUBRID last year
CUBRID last year I have a problem, I get back a blank result for some strings that I pass to cubrid_real_escape_string, this is a bit of a gray area as I do not know what the rules are about which text I can pass and which text I cannot. If I pass and image contents using this method the insert does not work as I get a blank return, An easy test is to try insert an image into a blob field escaping the data with cubrid_real_escape_string, the insert fails. - ![[Level:2]](http://www.cubrid.org/modules/point/icons/default/2.gif "Rank: 2/30, reputation score 26 (20% completed for the next level)")
andrevanzuydam last year
andrevanzuydam last year Why do you need to escape binary data? - CUBRID 11 months ago
CUBRID 11 months ago
1
Answer
0
mysql_escape_string() function has been deprecated as of PHP 5.3. mysql_real_escape_string() should be used instead.
In CUBRID PHP API there is a compatible cubrid_real_escape_string() function to escape strings. You can use it.
tagged
asked last year
viewed 650 times