Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Escape Special Characters in SQL statements
How To Escape Special Characters in SQL statements? - MySQL FAQs - Introduction to SQL Basics
✍: FYIcenter.com
There are a number of special characters that needs to be escaped (protected), if you want to include them in a character string. Here are some basic character escaping rules:
Here are some examples of how to include special characters:
SELECT 'It''s Sunday!' FROM DUAL; It's Sunday! SELECT 'Allo, C\'est moi.' FROM DUAL; Allo, C'est moi. SELECT 'Mon\tTue\tWed\tThu\tFri' FROM DUAL; Mon Tue Wed Thu Fri
2007-05-11, 7221👍, 0💬
Popular Posts:
What will happen in these three cases? if (a=0) { //somecode } if (a==0) { //do something } if (a===...
What are the two fundamental objects in ADO.NET ? Datareader and Dataset are the two fundamental obj...
Is XHTML Element Name Case Sensitive? - XHTML Tutorials - Introduction To Tag and Attribute Syntax Y...
Can each Java object keep track of all the threads that want to exclusively access to it?
Example of using Regular Expressions for syntax checking in JavaScript ... var re = new RegExp("^(&a...