Re: Uploading data to MS SQL Server - problem with quote cha


#1

Sam,

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.

On most all modern databases, a single quote must be quoted with

another single quote. For example, to update a value to the string “I
don’t know”:

UPDATE mytable SET mystring = ‘I don’‘t know.’

I hope this helps.

- Warren B.

#2

On Wednesday 04 January 2006 19:41, Warren B. wrote:

UPDATE mytable SET mystring = ‘I don’‘t know.’

I hope this helps.

- Warren B.

You’ll also want to escape the usual SQL special characters, namely
backslashes etc if this stuff occurs in your data. It’s an SQL thing,
not a
Ruby thing though. :slight_smile: