Smart Quotes - Unicode problems with SQL Server

[faust13]

I have an application that is posting data to a web page via a post request, which then inserts the data into SQL Server. If my users type in quotes (single or double), it creates a unicode friendly quote. However if they cut and paste a quote from a MS Word document (or any MS application), it preserves the smart quotes.

It looks like .Net uses Unicode internally, but does not substitute for smart quotes during data exchange.

Is there any way to suspend this "smart" quote behaviour?

Cheers. --------------------------------------
Is George Lucas Kidding...
Noise Core: 7.62

http://www.newmilitiarecords.com

 

[chiph]

No. Because once the text is pasted into your web form's text box, they're valid Unicode characters. The only reason the quotes are "smart", is because MSWord makes them that way.

If it really irks you, you could write code that looks for the normal single & double-quotes, and then backs up, looking for the reversed single & double quotes, changing them to the other kind. Could get tricky, especially if your users leave one of them off by accident.

Chip H.