Apostrophes not apostrophes

Discussion in 'Bug Reporting' started by Drawn_Steel_Hero, Sep 18, 2010.

  1. Drawn_Steel_Hero
    Drawn_Steel_Hero New Member
    I'm currently uploading all my I Ching pendant designs to my shop, and several of the names of the trigrams have apostrophes in them (such as Ch'ien, K'un, K'an etc). I type these apostrophes in as normal, but once the files are uploaded, the apostrophes have been changed automatically to quote marks ( " ). This means I have to go back into the model pages to change them all back to apostrophes, which is a bit of a bear when there are so many of them.

    [EDIT] Actually, I've just realised that the quote marks are actually double apostrophes, which is even weirder. So whenever I type an apostrophe, it turns it into two.
    Any idea why this is?

    Andy
     
    Last edited: Sep 18, 2010
  2. clsn
    clsn Well-Known Member
    I assume it's an escaping artifact, that apostrophes are doubled when being placed in the database since they're also used to quote the data. It's a common problem with SQL-style databases (and probably others too). Someone eventually is going to have to handle round-tripping that correctly.