SQL Escape / SQL Unescape Tool

How SQL Escapes Special Characters and Control Characters

SQL escape tool converts SQL to string online by escaping special reserved characters. Additionally, it also unescapes string to reverse the transformation. Generally, escape characters replace existing characters with new & provided characters, which works best without throwing any error at runtime. Escapes characters of a UTF-8 encoded Unicode string using SQL-style escape sequences. The utility escape plain SQL to escaped html which helps to show html text in SQL in <pre> tag.

How does SQL Escape Work?

• Type, paste, or upload your text data into the input box.
• Click 'Escape' or 'Unescape' your code.
  SQL Escape or SQL Unescape converter
• After you have converted your data, you can "Download" or "Copy to Clipboard".
• You can paste the code into your source code or text file.

What Characters are Replaced?

When you have a SQL string and need to work with it you will need to encode the string to allow parsing.
The following characters are reserved in SQL and need to be correctly escaped for use in strings:

• Tab is replaced with \t
• Backspace is replaced with \b
• Form feed is replaced with \f
• Newline is replaced with \n
• Carriage return is replaced with \r
• Double quote is replaced with \"
• Backslash is replaced with \\

All other characters passes through unchanged. Generally, alphanumeric characters 'a' through 'z, '0' through '9' remain the same.

SQL Escape Example

Plain SQL Before:

SELECT column_name1,
   column_name2
FROM table_name
WHERE column_name1 = 'express'

Escape SQL After:

SELECT column_name1,\n   column_name2\nFROM table_name\nWHERE column_name1 = \'express\'\n