Friday, February 24, 2012

Inserting Text into table replaces apostrophes with ?

When we insert text into field in a table, SQL SERVER apparently
replaces apostrophes with question marks -- is there a way to not have
this occur? We don't have this happen with the mySQL databases that
we also support.

Much help appreciated.I've encountered users coying and pasting text from MS Word and this exact
issue occurred. My problem was the MS 'smart quotes' so I had to replace
them prior to inserting.

Rob

"TNR" <stage7@.tgs.fr> wrote in message
news:bg3efc$jv5$1@.news-reader3.wanadoo.fr...
> Try to double the apostrophes.
> "kalbee" <kalbee@.einsof.com> wrote in message
> news:45082167.0307280703.29b9d428@.posting.google.c om...
> > When we insert text into field in a table, SQL SERVER apparently
> > replaces apostrophes with question marks -- is there a way to not have
> > this occur? We don't have this happen with the mySQL databases that
> > we also support.
> > Much help appreciated.

No comments:

Post a Comment