Hi, This question is answered at http://stackoverflow.com/questions/12779587/issue-with-using-csvread-in-h2-database-with-unicode-characters-as-delimiter
Regards, Thomas On Mon, Oct 8, 2012 at 8:10 AM, Sandeep Samudrala <[email protected]>wrote: > Hi, > > I am trying to use csvread to read from the testfile attached. The file > has CTRL-A (\u0001) as delimiter in between fields. > > The statement I used is > > select * from csvread('test.csv','id, name','charset=UTF-8 > fieldDelimiter=\u0001'); > > Expected Output: > > ID | Name > 12 | sandeep > > > Actual output: > > ID | Name > 12\u0001sandeep | null > > which means it is not picking \u0001 as the delimiter. > > Please let me know how to handle CTRL-A(\u0001) as delimiter while doing > csvread of a file. > > thanks in advance. > > -sandeep samudrala > > -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To view this discussion on the web visit > https://groups.google.com/d/msg/h2-database/-/h-KvhnLWuaEJ. > > 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. > -- 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.
