Quote/Apostrophe marks exporting as funny character

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Alan Z. Scharf - 12 Dec 2006 06:40 GMT

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

Reply to this Message

Character - 12 Dec 2006 12:59 GMT

> When I save a Word file and import it into SQLServer,the
> single quote mark/apostrophe gets imported and shows up in table text
[quoted text clipped - 17 lines]
>
> 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

Reply to this Message

Klaus Linke - 13 Dec 2006 01:21 GMT

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

> When I save a Word file and import it into SQLServer,the
> single quote mark/apostrophe gets imported and shows up in table text
[quoted text clipped - 17 lines]
>
> Alan

Reply to this Message

Alan Z. Scharf - 13 Dec 2006 13:07 GMT

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

> And as for the reason:
> You are probably saving as a Windows text file (code page Windows 1252?),
[quoted text clipped - 28 lines]
>>
>> Alan

Reply to this Message