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.