 |
|
| SAS/ACCESS Interface for MySQL |
Case Sensitivity for MySQL
In MySQL, databases and tables correspond to directories and files within those directories. Consequently, the case sensitivity of the underlying operating system determines the case sensitivity of database and table names. This means database and table names are not case sensitive in Windows, and case sensitive in most varieties of UNIX.
In SAS, names can be entered in either uppercase or lowercase. MySQL recommends that you adopt a consistent convention of either all uppercase or all lowercase table names, especially on UNIX hosts. This can be easily implemented by starting your server with -O lower_case_table_names=1. Please see the MySQL documentation for more details.
If your server is on a case-sensitive platform, and you choose to allow case sensitivity, be aware that when you reference MYSQL objects through the SAS/ACCESS interface, objects are case sensitive and require no quotation marks. Also, in the SQL pass-through facility, all MySQL object names are case sensitive. Names are passed to MySQL exactly as they are entered.
For more information about case sensitivity and MySQL names, see Naming Conventions for MySQL.
|
|
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.