[h2] Re: CSVREAD creates uppercased column names for single word names

2019-09-14 Thread George Ivanov
Thank you! -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To view this discussion on the web visit

[h2] Re: CSVREAD creates uppercased column names for single word names

2019-09-13 Thread Evgenij Ryazanov
On Saturday, 14 September 2019 04:28:30 UTC+8, George Ivanov wrote: > > sure! should one use caseSensitiveColumnNames anywhere else too? > I'm not sure what do you mean, but if you use quoted names of columns (" ColumnName") in your SQL commands, they are case sensitive by default. -- You

[h2] Re: CSVREAD creates uppercased column names for single word names

2019-09-13 Thread George Ivanov
sure! should one use caseSensitiveColumnNames anywhere else too? On Thursday, September 12, 2019 at 6:49:42 PM UTC+3, Evgenij Ryazanov wrote: > > I meant caseSensitiveColumnNames=true, of course. -- You received this message because you are subscribed to the Google Groups "H2 Database" group.

[h2] Re: CSVREAD creates uppercased column names for single word names

2019-09-12 Thread Evgenij Ryazanov
I meant caseSensitiveColumnNames=true, of course. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To view this

[h2] Re: CSVREAD creates uppercased column names for single word names

2019-09-12 Thread George Ivanov
Thank you! On Thursday, September 12, 2019 at 6:34:03 PM UTC+3, Evgenij Ryazanov wrote: > > No, it's not a bug. > > Such behavior is documented, but in obscure way: > https://h2database.com/html/functions.html#csvread > > Use caseSensitiveColumnNames option if you want to preserve case of >

[h2] Re: CSVREAD creates uppercased column names for single word names

2019-09-12 Thread Evgenij Ryazanov
No, it's not a bug. Such behavior is documented, but in obscure way: https://h2database.com/html/functions.html#csvread Use caseSensitiveColumnNames option if you want to preserve case of column names unconditionally. CSVREAD('filename.csv', NULL, 'caseSensitiveColumnNames=false') -- You