escaping strings in standard SQL 
Author Message
 escaping strings in standard SQL
In escaping a string to put in an SQL statement, I know that ' must be
doubled as ''.

I recently learned that PostgreSQL, which generally pays attention to
the standards, also requires escaping of \ as \\.  It will read '\' as
an unterminated string.  Does SQL92 or SQL99 speak to this?



Tue, 04 May 2004 05:38:08 GMT
 escaping strings in standard SQL

Quote:

> In escaping a string to put in an SQL statement, I know that ' must be
> doubled as ''.

> I recently learned that PostgreSQL, which generally pays attention to
> the standards, also requires escaping of \ as \\.  It will read '\' as
> an unterminated string.  Does SQL92 or SQL99 speak to this?

Definitely not SQL92.

--
Lee Fe{*filter*}an, FFE Software, Inc. ( http://www.***.com/ )
===================================================================
* Check out Database Debunkings ( http://www.***.com/ )
* "Where Persistent Prevailing Database Fallacies Are Dispelled"



Tue, 04 May 2004 14:44:17 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. non-standard escapes in string literals

2. non-standard escapes in string literals

3. non-standard escapes in string literals

4. Escaping strings for inclusion into SQL queriesh

5. Escaping strings for inclusion into SQL queries

6. Escaping strings for inclusion into SQL queries

7. Escaping strings for inclusion into SQL queries

8. Escape codes for SQL filter string using Access with MFC ODBC

9. SQL standard question: NULL vs. empty string

10. Escaping a date string.....

11. escaping spaces in query strings

12. Freetext searching on an escaped string


 
Powered by phpBB® Forum Software