Hi,
Ich hoffe es ist in Ordnung wenn ich in English antworte. Oder soll
ich eine deutschsprachige Google Gruppe erstellen?
Translation: I hope it's OK if I reply in English. Or would you prefer
if I create a German speaking Google Group?
-------------
This is not properly documented, and there are no examples in the
documentation. I will improve this.
A space needs to be escaped with a backslash ("\ "), and
a backslash needs to be escaped with another backslash ("\\").
All other characters are not to be escaped, that means
newline and tab characters are written as such.
-- Write a tab-separated file
CALL CSVWRITE('data/test.tsv', 'SELECT * FROM TEST', 'charset=UTF-8
fieldSeparator=' || CHAR(9));
-- Read a tab-separated file
SELECT * FROM CSVREAD('data/test.tsv', null, 'rowSeparator=' || CHAR(9));
Regards,
Thomas
--
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.
