Wednesday, March 21, 2012

MSWord smart quotes and SQL Server

We use Lyris Listmanager to send out bulk email - the product uses SQL
server. If someone cuts and pastes into the email product from Word, and
there are smart quotes in the document, they show up as ? marks on our
website. The emails go out fine, and IE displays smart quotes if I don't ge
t
them from SQL, so I am assuming the problem is with SQL. Has anyone had thi
s
problem and if so, please tell me how you corrected it. We tried adding cod
e
to our pages to find the ascii codes for smart quotes and it doesn't find
them.I haven't seen it, but I would suggest just using replace to get rid of the
wacky quotes:
replace (column,'"','"')
The smart quotes look good in a document, but when I wrote my book, they
turned code sample quotes to smart quotes so much it drove me banannas.
----
Louis Davidson - http://spaces.msn.com/members/drsql/
SQL Server MVP
"Arguments are to be avoided: they are always vulgar and often convincing."
(Oscar Wilde)
"yorkie" <yorkie@.discussions.microsoft.com> wrote in message
news:F6B9B990-D4B6-4FC8-BD71-D970E737AEBA@.microsoft.com...
> We use Lyris Listmanager to send out bulk email - the product uses SQL
> server. If someone cuts and pastes into the email product from Word, and
> there are smart quotes in the document, they show up as ? marks on our
> website. The emails go out fine, and IE displays smart quotes if I don't
> get
> them from SQL, so I am assuming the problem is with SQL. Has anyone had
> this
> problem and if so, please tell me how you corrected it. We tried adding
> code
> to our pages to find the ascii codes for smart quotes and it doesn't find
> them.|||Thanks, we actually tried that and were not successful, it messed up the
field and the newsletter would not display at all. Appreciate the advise th
o!
"Louis Davidson" wrote:

> I haven't seen it, but I would suggest just using replace to get rid of th
e
> wacky quotes:
> replace (column,'"','"')
> The smart quotes look good in a document, but when I wrote my book, they
> turned code sample quotes to smart quotes so much it drove me banannas.
> --
> ----
--
> Louis Davidson - http://spaces.msn.com/members/drsql/
> SQL Server MVP
> "Arguments are to be avoided: they are always vulgar and often convincing.
"
> (Oscar Wilde)
> "yorkie" <yorkie@.discussions.microsoft.com> wrote in message
> news:F6B9B990-D4B6-4FC8-BD71-D970E737AEBA@.microsoft.com...
>
>|||It shouldn't mess up the data in the output, unless there is other wierdness
going on. Could it have been that the double quotes were then the problem?
I think you have to use an escape character of some sort, I think it is:
"
So try:
replace (column,'"','"')
I am not a web programmer, so I am just guessing about this part, but it is
a possibility.
If this doesn't work, can you post an example? one thing to try is to use
ascii ('?') where the ? represents the data you are trying to replace, if
that is the problem. The smart quotes in the web page may be some other
escaped sequence of characters too.
----
Louis Davidson - http://spaces.msn.com/members/drsql/
SQL Server MVP
"Arguments are to be avoided: they are always vulgar and often convincing."
(Oscar Wilde)
"yorkie" <yorkie@.discussions.microsoft.com> wrote in message
news:781E9DC1-53B5-42F2-9B42-DD8E9BF8AED5@.microsoft.com...
> Thanks, we actually tried that and were not successful, it messed up the
> field and the newsletter would not display at all. Appreciate the advise
> tho!
> "Louis Davidson" wrote:
>sql

No comments:

Post a Comment