Hello,

> We selected Firebird SQL for our embedded system and now I'm writing
> Java code for our application.
>
> I tried to look everywhere in the net for information how to escape
> characters like ' from strings, but I didn't find anything..
>
> So how to do this in firebird
>
> insert into table (col1,col2) values('Root's test string', 'string
> 2');

Repeat your single quote so you get two single quotes:

Values ('Root''s test string', ...

> table is described to have two colums both varchar(100)

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com