Quote/Apostrophe marks exporting as funny character

[Alan Z. Scharf]

When I save a Word file and import it into SQLServer,the
single quote mark/apostrophe gets imported and shows up in table text

as 'Æ.'

(I don't know if this character will come through in plain text to
newsgroup.)

It looks like a combined AE, with the right leg of the A vertical and
serving also as the vertical part of the E.

Is there any way to force the character into a plain text
quote/apostrophe?

I tried replacing the quote marks with 'XXXXX' and then replacing that
back
to the single quote mark, but that didn't clean it out.

Thanks.

Alan

[Character]

Post by Alan Z. Scharf
When I save a Word file and import it into SQLServer,the
single quote mark/apostrophe gets imported and shows up in table text
as 'Æ.'
(I don't know if this character will come through in plain text to
newsgroup.)
It looks like a combined AE, with the right leg of the A vertical and
serving also as the vertical part of the E.
Is there any way to force the character into a plain text
quote/apostrophe?
I tried replacing the quote marks with 'XXXXX' and then replacing that
back
to the single quote mark, but that didn't clean it out.
Thanks.
Alan

Try turning OFF "smart quotes" when creating your Word file.
In Word 2003, Tools / Autocorrect options / Autoformat as you type /
UNcheck "Straight quotes with Smart quotes"

Character

[Klaus Linke]

And as for the reason:
You are probably saving as a Windows text file (code page Windows 1252?),
but SQLServer reads it as DOS text.
If you'd save the file as MS-DOS text in the first place, you would avoid
some problems.
But the DOS code page doesn't contain smart quotes, so they might turn into
question marks.
Maybe you could have SQLServer import it as Windows text?

Klaus

Post by Alan Z. Scharf
When I save a Word file and import it into SQLServer,the
single quote mark/apostrophe gets imported and shows up in table text
as 'Æ.'
(I don't know if this character will come through in plain text to
newsgroup.)
It looks like a combined AE, with the right leg of the A vertical and
serving also as the vertical part of the E.
Is there any way to force the character into a plain text
quote/apostrophe?
I tried replacing the quote marks with 'XXXXX' and then replacing that
back
to the single quote mark, but that didn't clean it out.
Thanks.
Alan

[Alan Z. Scharf]

Character and Klaus,

Thanks ver much for both your replies on the autocorrect and the
implications of text import.

I have to check on the available forms of text import available in
SQLServer.

All this is startting to make sense.

Thanks again

Post by Klaus Linke
You are probably saving as a Windows text file (code page Windows 1252?),
but SQLServer reads it as DOS text.
If you'd save the file as MS-DOS text in the first place, you would avoid
some problems.
But the DOS code page doesn't contain smart quotes, so they might turn
into question marks.
Maybe you could have SQLServer import it as Windows text?
Klaus

Post by Alan Z. Scharf
When I save a Word file and import it into SQLServer,the
single quote mark/apostrophe gets imported and shows up in table text
as 'Æ.'
(I don't know if this character will come through in plain text to
newsgroup.)
It looks like a combined AE, with the right leg of the A vertical and
serving also as the vertical part of the E.
Is there any way to force the character into a plain text
quote/apostrophe?
I tried replacing the quote marks with 'XXXXX' and then replacing that
back
to the single quote mark, but that didn't clean it out.
Thanks.
Alan