Community
    • Login

    How to automate escaping apostrophes in sql

    Scheduled Pinned Locked Moved Help wanted · · · – – – · · ·
    1 Posts 1 Posters 1.4k Views
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • Carlos DanielC
      Carlos Daniel
      last edited by

      Hi,

      I’m trying to develop a way to turn this:

      insert into table (content) values (‘it’s a boy’)

      into this:

      insert into table (content) values (‘it’‘s a boy’)

      Basically i’m dealing with fields in a query that the user fills with an apostrophe, which i then have to escape, by doubling that apostrophe. In a perfect world this would be dealt with in the frontend application, however this is not an option. I have to manually correct these queries, and as you can imagine, it’s very time consuming. Can you help me find some sort of macro that would fix these queries ?

      Thanks.

      1 Reply Last reply Reply Quote 0
      • First post
        Last post
      The Community of users of the Notepad++ text editor.
      Powered by NodeBB | Contributors