when i'insert a data with quotes into table i get the error
something like this
insert into table(string_field0) values(' 'test' ')

why inserting string with quotes is a little problem ?
this problem is in all databases ?

only one solution is to use replace function , like
Replace(Str," ' "," '")

In MSSQL server, you have to use two quotes to insert into a table:

insert into table
(col1) values ('''Test''')

DMW