Hello, i get the same issue when inserting directly from an SQL file with a SimpleJdbcTestUtils.
Any solutions ? Thanks On 10 mar, 14:03, JerMoo <[email protected]> wrote: > 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.
