Hi Thomas,
Stellar work on H2. I love it!
I have a question for you. Is there a way preserve the whitespaces in
a row when importing via CSVREAD? I am importing the following rows
using the below statement
CREATE TABLE tbl_1_name_csv as ( SELECT * FROM CSVREAD('C:\h2import
\numbers.csv' ,null, 'UTF-8', ',') );
Rows:
123456789 ,0,y,356
123456789,1,n,839
The issue is that the white space in the first row is being trimmed
and this needs to be preserved for data integrity reasons. Is there an
option with H2 to ensure whitespaces are not ignored or trimmed? I
took a peek at org.h2.tools.Csv.readValue and saw that white spaces
are ignored.
Thanks,
JerMoo
--
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.
