> I am having trouble querying Firebird for data that may contain
> apostrophes
> from PHP. I think the problem may be with the PHP interbase functions, and
> wonder if anyone has any experience of doing this?
>
> Escaping the apostrophe with a backslash at the PHP level doesn't help
> (Firebird doesn't recognize the escape sequence).
>
> I have eventually managed to enclose the literal containing the apostrophe
> in double quotes at the PHP level, but now Firebird thinks I'm trying to
> compare two columns.
>
> Surely this must be a common problem with a simple solution. Does anyone
> know what it is?
>
> PS: I have asked on the PHP-DB list, but the response has been
> poor so far.
>
> Any help is appreciated.
>
> Thanks
>
> Evan Morris

Have you set magic quote for sybase on? Don't forget there 's a list for PHP
and Firebird..
firebird-php@yahoogroups.com

Alan