SQL Unescape
Turn a doubled SQL apostrophe back into one, so a value copied out of a statement reads normally again.
What unescaping SQL does
Each pair of apostrophes becomes one. A single apostrophe with no partner is left as it is rather than treated as an error, because a fragment cut out of a statement often starts or ends mid-literal and this page is meant to make that fragment readable. The result is text, not a statement: nothing here parses SQL or checks it against a schema.
How to use it
SQL Unescape: paste the escaped SQL into the box above, and press Run to get the text below.
Worked example
Input:
O''Brien said ''hi''
Output:
O'Brien said 'hi'
Why it runs in your browser
The conversion happens on this page with JavaScript. Your input is not posted to a server, so it works offline after the page loads and nothing is retained anywhere. The page reads escaped SQL and returns text; reloading the page discards both.
Each pair of apostrophes becomes one. A single apostrophe with no partner is left as it is rather than treated as an error, because a fragment cut out of a statement often starts or ends mid-literal and this page is meant to make that fragment readable. The result is text, not a statement: nothing here parses SQL or checks it against a schema.
Turn a doubled SQL apostrophe back into one, so a value copied out of a statement reads normally again.
How to use it
SQL Unescape: paste the escaped SQL into the box above, and press Run to get the text below.
Why it runs in your browser
The conversion happens on this page with JavaScript. Your input is not posted to a server, so it works offline after the page loads and nothing is retained anywhere. The page reads escaped SQL and returns text; reloading the page discards both.
What to Expect
Best for
- Converting escaped SQL to text when the data is already on screen.
What this tool keeps
- Your input is not posted to a server, so it works offline after the page loads and nothing is retained anywhere.
Sample input
O''Brien said ''hi''
Sample output
O'Brien said 'hi'
Frequently asked questions
How do I use the sql unescape?
SQL Unescape: paste the escaped SQL into the box above, and press Run to get the text below.
Is my input uploaded?
No. The text is parsed on this page with JavaScript and is never posted to a server.
Is there a size limit?
Yes: 5 MB per run. Larger input is refused with a message rather than freezing the tab.
Build custom tools for your store
Join the SDK program to create useful ecommerce utilities for your store.