Inserting Text into table replaces apostrophes with ?

#1

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.

#2

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 (AT) tgs (DOT) fr> wrote

Quote:

Try to double the apostrophes.

"kalbee" <kalbee (AT) einsof (DOT) com> wrote in message
news:45082167.0307280703.29b9d428 (AT) posting (DOT) google.com...
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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Inserting Text into table replaces apostrophes with ?

comp.databases.ms-sqlserver comp.databases.ms-sqlserver

Inserting Text into table replaces apostrophes with ? - 07-28-2003 , 10:03 AM

Re: Inserting Text into table replaces apostrophes with ? - 07-28-2003 , 10:17 AM