Hi, I understand. The next version of H2 will have a new feature to preserve the case sensitivity of column names (option caseSensitiveColumnNames).
Regards, Thomas On Friday, January 20, 2012, Douglas Alan wrote: > Hi. I recently used H2 for its ability to parse, manipulate, and > filter CSV files. (Or in my case, a TSV file.) It worked great, so I > think H2 is da bomb! > > My only complaint would be that H2 canonicalized the TSV headers to be > all uppercase. I can see that this is often the desired behavior in > order to make SQL queries easier to write. But in my case this > behavior wasn't quite optimal, as I was writing out TSV files that > were filtered versions of the input files, and I needed the headers to > be exactly preserved. > > This was no biggie: I just had to do some extra work to reopen the TSV > file myself and re-extract the headers in my own code so that I could > write out the unmolested headers to the output files. In general, it > would have be a lot more convenient, however, if H2's CSV reader were > to have an option to leave the CSV headers alone. If this enhancement > were made, H2 would be the uber CSV manipulation tool! > > |>ouglas > > -- > 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. > > -- 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.
