Subject Handling quote characters in Firebird/PHP
I am running Firebird 1.5 Super Server on a Windows 2000 box with
Apache/PHP4. When trying to enter text data into a Firebird database, I
have specific stored procedures that handle the updating of various tables.
Text data that contains a single quote character in it (ie. O'Connell, etc.)
is causing errors in Firebird when executing the query. This is typically
due to the fact that I put quotes around the text fields in order to send
them as a arguments to the stored procedures.

What is the best practice way of handling fields with single quote
characters purposely entered into them, and getting this data into Firebird?


Myles Wakeham
Director of Engineering
Tech Solutions US, Inc.
Scottsdale, Arizona USA
Phone (480) 451-7440