Description:
mysql> show variables like "lower%";
+------------------------+-------+
| Variable_name | Value |
+------------------------+-------+
| lower_case_file_system | OFF |
| lower_case_table_names | 0 |
+------------------------+-------+
2 rows in set (0.00 sec)
mysql> select version();
+----------------+
| version() |
+----------------+
| 5.0.15-max-log |
+----------------+
1 row in set (0.00 sec)
mysql> select * from SCHEMATA;
+--------------+--------------------+----------------------------+------------------------+----------+
| CATALOG_NAME | SCHEMA_NAME | DEFAULT_CHARACTER_SET_NAME | DEFAULT_COLLATION_NAME | SQL_PATH |
+--------------+--------------------+----------------------------+------------------------+----------+
| NULL | information_schema | utf8 | utf8_general_ci | NULL |
| NULL | DS2 | latin1 | latin1_swedish_ci | NULL |
| NULL | mysql | latin1 | latin1_swedish_ci | NULL |
| NULL | test | latin1 | latin1_swedish_ci | NULL |
+--------------+--------------------+----------------------------+------------------------+----------+
4 rows in set (0.00 sec)
mysql> select SCHEMA_NAME, length(SCHEMA_NAME) from SCHEMATA;
+--------------------+---------------------+
| SCHEMA_NAME | length(SCHEMA_NAME) |
+--------------------+---------------------+
| information_schema | 18 |
| DS2 | 3 |
| mysql | 5 |
| test | 4 |
+--------------------+---------------------+
4 rows in set (0.00 sec)
mysql> use test;
Database changed
mysql> use DS2;
ERROR 1049 (42000): Unknown database 'DS2;'
mysql> create database ABC;
Query OK, 1 row affected (0.01 sec)
mysql> use ABC;
ERROR 1049 (42000): Unknown database 'ABC;'
mysql> use "ABC";
Database changed
mysql> SELECT DATABASE(), LENGTH(DATABASE());
+------------+--------------------+
| DATABASE() | LENGTH(DATABASE()) |
+------------+--------------------+
| ABC | 3 |
+------------+--------------------+
1 row in set (0.00 sec)
mysql> create database abc;
Query OK, 1 row affected (0.04 sec)
mysql> use abc;
ERROR 1049 (42000): Unknown database 'abc;'
mysql> use abc
Database changed
mysql> use "ABC";
Database changed
Should be ReiserFS.
nixnutz@linux:/tmp/mysql_test> ls -la
insgesamt 2
drwxr-xr-x 2 nixnutz users 48 2005-10-28 10:21 .
drwxrwxrwt 21 root root 1528 2005-10-28 10:21 ..
nixnutz@linux:/tmp/mysql_test> touch ABC
nixnutz@linux:/tmp/mysql_test> touch abc
nixnutz@linux:/tmp/mysql_test> ls -la
insgesamt 2
drwxr-xr-x 2 nixnutz users 96 2005-10-28 10:21 .
drwxrwxrwt 21 root root 1528 2005-10-28 10:21 ..
-rw-r--r-- 1 nixnutz users 0 2005-10-28 10:21 abc
-rw-r--r-- 1 nixnutz users 0 2005-10-28 10:21 ABC
nixnutz@linux:/tmp/mysql_test> ls -la abc
-rw-r--r-- 1 nixnutz users 0 2005-10-28 10:21 abc
nixnutz@linux:/tmp/mysql_test> ls -la ABC
-rw-r--r-- 1 nixnutz users 0 2005-10-28 10:21 ABC
nixnutz@linux:/tmp/mysql_test> uname -a
Linux linux 2.6.11.4-21.9-smp #1 SMP Fri Aug 19 11:58:59 UTC 2005 i686 i686 i386 GNU/Linux
How to repeat:
See above.