Strange apostrophe behaviour

Discussion in 'Web Design and Development' started by Craigy, Sep 19, 2011.

  1. Craigy macrumors 6502

    Joined:
    Jan 14, 2003
    Location:
    New Zealand
    #1
    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?
     
  2. Hansr macrumors 6502a

    Joined:
    Apr 1, 2007
    #2
    What's the defined charset for the browser being used and what is the collation for the SQL server?
     
  3. Craigy thread starter macrumors 6502

    Joined:
    Jan 14, 2003
    Location:
    New Zealand
    #3
    The page is UTF-8 ( <%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%> ) and the SQL Collation is Latin1_General_CI_AS.
     
  4. Hansr macrumors 6502a

    Joined:
    Apr 1, 2007
    #4
    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?
     

Share This Page