Example input/output
Input: it's a test
Output: it''s a test
How it works
This tool escapes single quotes by doubling them (standard ANSI SQL) and optionally escapes other characters depending on the target database dialect. Use parameterised queries in production — this tool is for quick inspection only. Processing runs in your browser.
Common use cases
- Escape single quotes and special characters before inserting strings into SQL queries
- Prepare text values for use in SQL INSERT or UPDATE statements
- Debug SQL injection vulnerabilities by inspecting escaping behaviour