# Uploading data to MS SQL Server - problem with quote charact

**URL:** <https://www.ruby-forum.com/t/uploading-data-to-ms-sql-server-problem-with-quote-charact/51646>\
**Category:** Ruby\
**Created:** [January 5, 2006, 2:06am UTC](https://www.ruby-forum.com/t/uploading-data-to-ms-sql-server-problem-with-quote-charact/51646 "2006-01-05T02:06:38Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![samckayak](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/58f4c7/32.png) [@samckayak](https://www.ruby-forum.com/u/samckayak)\
**Post date:** [January 5, 2006, 2:06am UTC](https://www.ruby-forum.com/t/uploading-data-to-ms-sql-server-problem-with-quote-charact/51646/1 "2006-01-05T02:06:38Z")

</div>

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