note 8378 added to InterBase functions
| From: | tummarel at ascu dot unian dot it | Date: | Fri, 08 Sep 2000 15:06:19 +0000 |
| Subject: | note 8378 added to InterBase functions | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-4543@lists.php.net to get a copy of this message | ||
We have spent several hours searching for a solution for to insert the ' caracter succesfully
into a Interbase query. Interbase 6.0 for some reason uses the ' as escape character instead of
the \ .. writing as imple function to transofm ' into '' wil do the trick into the
insert mode but it will not work doing a select (since you'll have an added \"
THE SOLUTION:
In the php.ini file set
magic_quotes_sybase = On ; Use Sybase-style magic quotes (escape ' with '' instead of
\')
i hope this helps: :-)i am quite amazed this is not clearly stated anywere.
ketword: interbase escape character
http://www.php.net/manual/ref.ibase.php