Uploading data to MS SQL Server - problem with quote charact

Hi,

I’m a ruby newbie. On one project I have, I need to upload data coming
from Oracle database to an MS SQL Server. But I’m having problems
inserting if data contains a quote (’) character. Is there a method
within the dbi ODBC to quote the data?

Thanks,
Sam