hi try this

insert into test values('I'||CHR(39)||'m good')

where CHR(39) is '