Subject Re: Escape single quote (apostrophe)
Author Adam
--- In firebird-support@yahoogroups.com, Jeff Dunlap
<jeff_j_dunlap@...> wrote:
>
> I am wondering if there is something that FB offers to escape single
quotes found within strings of text.
>
> For example:
>
> sText = "Tom's Webpage";
>
> This string of text will cause a FB error to occur unless you
escape the single quote with two of them.
>
> Is there something available to handle this on the server or is
does the client just have to do the escaping before sending to FB?

What is your client language/environment?

Most languages have some sort of idea of a paramatised query which
takes care of necessary escaping.

Adam