Hi Antoine, I havent had the time to write this patch, but hope to do so in the coming weeks.
Thanks, Jerome On May 4, 1:49 pm, Antoine Véret <[email protected]> wrote: > 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.
