Hi Jérome, i hope too Thanks
On 5 mai, 10:40, JerMoo <[email protected]> wrote: > 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.
