error in loading rows from a csv file having \u0001 as the delimiter

Before submitting a bug, please check the FAQ:
http://www.h2database.com/html/faq.html

What steps will reproduce the problem?
(simple SQL scripts or simple standalone applications are preferred)
1.store two columns in a line with delimiter as ctrl-A(\u0001) and save it
12^Asandeep
2.read it from db using 
select * from csvread('test.csv','id,name','charset=UTF-8 fieldDelimiter=^A'); 
where ^A is \u0001 i.e Ctrl-A

3.I am attaching the test.csv file so that the ctrl-A character is well 
understood.

What is the expected output? What do you see instead?

id | name
12 | sandeep
instead i am seeing it as 
id | name
12^A| null
Expected output
What version of the product are you using? On what operating system, file
system, and virtual machine?

Do you know a workaround?

What is your use case, meaning why do you need this feature?

How important/urgent is the problem for you?

Please provide any additional information below.

thanks,
-Sandeep Samudrala

Original issue reported on code.google.com by sandys...@gmail.com on 5 Oct 2012 at 1:02

Attachments:

test.csv

sagarswathi / h2database

error in loading rows from a csv file having \u0001 as the delimiter #421