Hi,
Since it is a java system property it will affect all new databases in
current jvm. Not sure about existing ones.
This setting does not affect the database file, therefore it's save to
use it with existing databases.
Regards,
Thomas
--
You received this message because you are
I'm playing around with H2 for the first time, using jdbc.
I created a table where the column titles are mixed case, but they are
showing up in the H2 table viewer as all caps. Is this normal?
Thanks.
--
You received this message because you are subscribed to the Google Groups H2
Database
Hi,
This is normal. By default all names are case insensitive and in upper
case. You can use double quotes if you want to preserve case like
columnName or you can define system property h2.identifiersToUpper
to false.
On 11 окт, 11:02, puzzler mark.engelb...@gmail.com wrote:
I'm playing around
On Oct 11, 12:16 am, Sergi Vladykin sergi.vlady...@gmail.com wrote:
Hi,
This is normal. By default all names are case insensitive and in upper
case. You can use double quotes if you want to preserve case like
columnName or you can define system property h2.identifiersToUpper
to false.
How do
See
http://h2database.com/javadoc/org/h2/constant/SysProperties.html#h2.identifiersToUpper
It is just a plain java system property which you can set as command
line argument like
java -Dh2.identifiersToUpper=false ..
or if you use h2 as an embedded database you can set in your code
before