H2 allows you to put double quotes around column names and table names in
order to preserve case. I believe this is standard functionality in other
databases as well, e.g.:
create table "testTable" ("testId" int8, "testData" varchar(50));
I have not seen camel case used commonly in SQL, but this is a stylistic
matter and I don't know of good reasons why it shouldn't be used.
- Johann
On Tue, Mar 3, 2009 at 12:57 AM, Sharad <[email protected]> wrote:
>
> 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
-~----------~----~----~----~------~----~------~--~---
