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.
on 2006-01-05 03:42
on 2006-01-06 08:19
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. :-)