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


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