When we create tables in H2 all column names get automatically
converted to UPPER CASE.

Is there any way to avoid this behavior and permit camel case ( mixed
case ) in column names..

Commonly  used database servers handle this issues awkwardly.

(1) MySQL, MS SQL and SQLite preserve the column case .
(2) Postgre converts all column names to lower case.
(3) IBM-DB2 and Oracle convert all the column names into UPPER CASE.

Is it not a good practice to preserve case in column name ?

There are many automatic Java class generation tools which create Java
class code according to table definition. They create one member
variable per column.
In this situation will not be a good practice to preserve the case of
column names and allow mix case ( camel case  ) in column names.

Thanks
Sharad Kelkar


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to 
[email protected]
For more options, visit this group at 
http://groups.google.com/group/h2-database?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to