Strange apostrophe behaviour

[Craigy]

Hi - We look after a site for someone. On one of the pages there is a text input box that gets stored in MS SQL Server as NTEXT. One of their clients has raised the question that every time they write the word "don't" into their description, it gets displayed in their profile as:

d’t

I did a search on Google for ’ and it's all over the place!

I suspect something like MS Word special chars or something is causing the issue.

Anyone else come across this?

 

[Hansr]

What's the defined charset for the browser being used and what is the collation for the SQL server?

 

[Craigy]

What's the defined charset for the browser being used and what is the collation for the SQL server?

The page is UTF-8 ( <%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%> ) and the SQL Collation is Latin1_General_CI_AS.

 

[Hansr]

That's weird should be fine then but maybe it's something weird at their end? I'm assuming it doesn't happen in your browser. Could be something related to their browser choice + locale for Windows?