• Login
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.
  • C
    Carlos Daniel
    last edited by Jul 25, 2016, 6:27 PM

    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
    1 out of 1
    • First post
      1/1
      Last post
    The Community of users of the Notepad++ text editor.
    Powered by NodeBB | Contributors