SQL illegal character question 
Author Message
 SQL illegal character question
Hi ,
does anyone know which characters SQL Server 7 does not support?
I know that in order to enter an apostrophe you need to replace it with two
apostrophes ("my dad's car" is to be replaced with "my dad''s car" in order
to be inserted correctly). Are there any other signs?  Is there any
documentation regarding this phenomenon?

Thanks in advance,
Uzi




Thu, 19 Jun 2003 23:16:16 GMT
 SQL illegal character question

there's quite a bit of documentation. check out SQL BOL, search on
"strings", "delimiters" and "character" for starters.

-- Mary
Microsoft Access Developer's Guide to SQL Server
http://www.amazon.com/exec/obidos/ASIN/0672319446/

Quote:

>Hi ,
>does anyone know which characters SQL Server 7 does not support?
>I know that in order to enter an apostrophe you need to replace it with two
>apostrophes ("my dad's car" is to be replaced with "my dad''s car" in order
>to be inserted correctly). Are there any other signs?  Is there any
>documentation regarding this phenomenon?

>Thanks in advance,
>Uzi





Fri, 20 Jun 2003 02:10:43 GMT
 SQL illegal character question
Uzi - there are no illegal characters.  Single quotes are held just fine - you
just have to double them up so the SQL parser knows to insert them.

 Neil Pike MVP/MCSE.  Protech Computing Ltd
 Reply here - no email
 SQL FAQ (484 entries) see
 http://forumsb.compuserve.com/gvforums/UK/default.asp?SRV=MSDevApps
 (faqxxx.zip in lib 7)
 or www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
 or www.sqlserverfaq.com
 or www.mssqlserver.com/faq



Fri, 20 Jun 2003 19:32:02 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. SQL illegal character question

2. OCI8: illegal characters in SQL

3. illegal character in sql statement (#202) in kind of using SAP

4. Illegal Characters in SQL

5. Illegal 'characters'?

6. XML BulkLoad error, Illegal qualified name character

7. Updategram illegal characters

8. Illegal Character (server.htmlencode ?)

9. Illegal Characters.

10. illegal character list?

11. Illegal characters

12. Illegal Xml character


 
Powered by phpBB® Forum Software