I have this file:
C:\tmp2>type iris3.dat
Sepal.Length,Sepal.Width,Petal.Length,Petal.Width,Species
5.1,3.5,1.4,0.2,setosa
4.9,3,1.4,0.2,setosa
4.7,3.2,1.3,0.2,setosa
and in the H2 console I issue this command:
select * from csvread('C:\tmp2\iris3.dat');
but I get back this where SPECIES is upper case and all the other
column names have the correct case.
select * from csvread('C:\tmp2\iris3.dat');
Sepal.Length Sepal.Width Petal.Length Petal.Width SPECIES
5.1 3.5 1.4 0.2 setosa
4.9 3 1.4 0.2 setosa
4.7 3.2 1.3 0.2 setosa
Why the inconsistency in which it converts Species to upper case but
not the other column names? What do I do so that it leaves all
column names as the original case?
Also is there some way to set the correct column types (the first 4
should be real) other than tediously writing out a cast for each one?
I am using H2 1.3.160 on Windows Vista.
Thanks.
--
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.
