[opencms-dev] opencms database case sensitivity?

[Mario Jäger]

Hi Chris,

The OpenCms table names were always already in upper case. It depends on 
your operating system and on your database configuration, if the table 
names are created in upper case or in lower case. For example, in a 
MySQL database the configuration of the system variable 
"lower_case_table_names" is responsible for that. That variable can have 
the values 0, 1 and 2. If it is set to 0, than the table names are 
created like given in the "CREATE TABLE" statements and the case 
sensitive is distinguished, when using the table names in SQL 
statements. This is the default setting in UNIX systems. If the variable 
is set to 1, than the table names are created in lower case and the case 
sensitive is not distinguished, when using the table names in SQL 
statements. This is the default setting in Windows systems. If the 
variable is set to 2, than the table names are created like given in the 
"CREATE TABLE" statements, but there is no case sensitive distinguished, 
when using the table names in SQL statements (while lookup MySQL 
converts the table names to lower case). This is the default setting in 
Mac OS X systems.

And the SQL statements in OpenCms itself uses the table names like given 
in the "CREATE TABLE" statements. That is why, there are no problems, 
whatever operating system you use and how the system variable 
"lower_case_table_names" is set in your system (if you use a MySQL 
database).

-- 
Kind Regards,
Mario.

-------------------
Mario Jäger

Alkacon Software GmbH  - The OpenCms Experts
http://www.alkacon.com - http://www.opencms.org

Am 10.12.2010 12:44, schrieb Christoph P. Kukulies:
> I'm puzzled: Why is it that the database tables in opencms
> (7.5.3) are now in caps? :
>
> +--------------------------------+
> | Tables_in_opencms              |
> +--------------------------------+
> | CMS_CONTENTS                   |
> | CMS_GROUPS                     |
> | CMS_GROUPUSERS                 |
> | CMS_HISTORY_PRINCIPALS         |
> | CMS_HISTORY_PROJECTRESOURCES   |
> | CMS_HISTORY_PROJECTS           |
> | CMS_HISTORY_PROPERTIES         |
> | CMS_HISTORY_PROPERTYDEF        |
> | CMS_HISTORY_RESOURCES          |
> | CMS_HISTORY_STRUCTURE          |
> | CMS_OFFLINE_ACCESSCONTROL      |
> | CMS_OFFLINE_CONTENTS           |
> | CMS_OFFLINE_PROPERTIES         |
> | CMS_OFFLINE_PROPERTYDEF        |
> | CMS_OFFLINE_RESOURCES          |
> | CMS_OFFLINE_RESOURCE_RELATIONS |
> | CMS_OFFLINE_STRUCTURE          |
> | CMS_ONLINE_ACCESSCONTROL       |
> | CMS_ONLINE_PROPERTIES          |
> | CMS_ONLINE_PROPERTYDEF         |
> | CMS_ONLINE_RESOURCES           |
> | CMS_ONLINE_RESOURCE_RELATIONS  |
> | CMS_ONLINE_STRUCTURE           |
> | CMS_PROJECTRESOURCES           |
> | CMS_PROJECTS                   |
> | CMS_PUBLISH_HISTORY            |
> | CMS_PUBLISH_JOBS               |
> | CMS_RESOURCE_LOCKS             |
> | CMS_STATICEXPORT_LINKS         |
> | CMS_USERDATA                   |
> | CMS_USERS                      |
> +--------------------------------+
> 31 rows in set (0.00 sec)
>
>
> --
> Chris Christoph P. U. Kukulies kukulies (at) rwth-aachen.de
>
> _______________________________________________
> This mail is sent to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please visit
> http://lists.opencms.org/mailman/listinfo/opencms-dev