SQL Unescape screenshot

SQL Unescape

Turn a doubled SQL apostrophe back into one, so a value copied out of a statement reads normally again.

Privacy First
0 Runs
Updated 2026-11-06
No upload
Instant
No signup

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.

Developer program

Build custom tools for your store

Join the SDK program to create useful ecommerce utilities for your store.