Hello,
according to my observations and tests, it looks like, that the latest
stable H2, 1.3.176, has a bug or missing capability or documented
limitation. All about one thing - separator of lines of CSV file to be read
using csvread. Let assume following code:
create table t1 (id int, name varchar(255));
insert into t1 (id, name) values (01, 'a');
insert into t1 (id, name) values (02, 'b');
select * from t1;
-- OK
call csvwrite('C:\temp\temp\logdb\test3.txt', 'select * from t1',
'charset=UTF-8 fieldSeparator=x fieldDelimiter= lineSeparator=y');
-- not OK
select * from csvread('C:\temp\temp\logdb\test3.txt', null, 'charset=UTF-8
fieldSeparator=x fieldDelimiter= lineSeparator=y');
The latest command interprets the output of previous command wrong.
Use case ~ why I want it. Very detailed explanation is described at How to
put into the CSV (text) output of XSL-T 2.0 transformation XML illegal
characters like 1E “record separator” and 1F “unit separator”?
<http://stackoverflow.com/questions/25669441/how-to-put-into-the-csv-text-output-of-xsl-t-2-0-transformation-xml-illegal-ch>
article of StackOverflow. Shortly: while fast processing huge load of (let
say XML) input data to produce CSV, it is very inefficient to use string
replace-like functions to escape double quotes etc. I would like to use (in
case of XML 1.0) column and row separators ~ single characters, that could
not never appear in the source. So my choice in case of XML 1.0 are 1E and
1F.
I also think, that it could be consistent, that if csvwrite has such
capability, csvread does not. I already rise such feature request years ago
in the thead of this group
<https://groups.google.com/forum/#!searchin/h2-database/rowSeparator/h2-database/p7IFChKiNiQ/B80TRyBf4UkJ>.
Till now, I was able to bypass it using string-replace functions using awk,
xsl-t etc. but not know, because replacing is very time consuming.
Thank You in advance for your answer, Stepan
P.S.: What is the difference between lineSeparator and rowSeparator in
csvOprtion?
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
