MDAC 2.5 SDK - ODBC Desktop Database Drivers


 

Identifiers Limitations

If an identifier contains a space or a special symbol, the identifier must be enclosed in back quotes. A valid name is a string of no more than 64 characters, of which the first character must not be a space. Valid names cannot include control characters or the following special characters: ` | # * ? [ ] . ! $ .

Do not use the reserved words listed in the SQL grammar in Appendix C of the ODBC Programmer's Reference (or the shorthand form of these reserved words) as identifiers (that is, table or column names), unless you surround the word in back quotes (`).