jsonecho

SQL Unescape

Paste escaped SQL text and get the original characters back.

Loading the tool...

How to use SQL Unescape

  1. Paste the escaped text.
  2. Copy the readable result.

About SQL Unescape

The opposite direction is useful when you read a value out of a dump file or a log: '' becomes a single apostrophe again, and in MySQL style \n, \' and \\ are converted back.

Tick the wrap option if the text still has its surrounding single quotes, they are removed.

Frequently asked questions

Which style does the unescape expect?

Choose the same dialect that was used to escape the text. Standard mode collapses doubled quotes, MySQL mode converts backslash sequences.

Does it remove the surrounding quotes?

Only when you tick "Wrap in single quotes".

Can I unescape a whole INSERT statement?

Paste only the string values. A complete statement also has keywords and commas that should stay as they are.

More in Escape and Text

All tools →