Subject Re: [Firebird-Java] value with an apostrophe
Author Helen Borrie
At 09:25 AM 23/03/2004 +0800, you wrote:
>Maybe some of you have experience / encounter this problem. I try to
>insert an employee name into my database (interbase 6.0) for example
>Marina O'Reili (note the apostrophe ' ) will not be accepted as employee
>name. I think this is becuase Interbase will mix up the single and double
>quotes in insert and update statements. Any input on how to solve this problem?

You have to "escape" a literal apostrophe with another apostrophe:

update atable
set fname = 'Marina O''Reili'

That is 2 ascii-39, not one ascii-34.