Home Forums SQL Server 7,2000 Strategies Apostrophes and Double Quotes - Should They be Allowed in table Text-Type Columns? RE: Apostrophes and Double Quotes - Should They be Allowed in table Text-Type Columns?

  • Sean Lange (1/30/2012)


    Yes they should be allowed. The system should NEVER NEVER NEVER change the data. The job of sql is store and retrieve data. If there are challenges to retrieving that data then it should be handled by sql.

    Isn't allowing them just asking for trouble? I recently witnessed a 3rd party application throw an error, simply because of a quote. So it is the 3rd party's developer's fault then? I'm playnig a devil's advocate here, but I can see both sides of this.

    The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge. - Stephen Hawking