I found that Single quote ( ' ) cannot be stored in gadfly database table.

If gadfly is like every other db, it will store ' but you have to escape it first since it is the delimiter for string vals. In access, sqlserver you add a second ' to escape. That should work, or use backslash.