Hi,
I'm trying to use CVSREAD to read a file separated by tabs into a four
column table.
The four datatypes of the columns are int, bigint, tinytext, datetime.
I'm using Java to execute the commands.
CSVREAD(~\\example\\file.tsv', null, 'UTF-8', chr(9))
I am getting a problem with this specific record:
2615 3320534942 "What's foursquare?" Todd: "It's Dungeons & Dragons
for drunks." 2009-08-14 21:01:30
The error is:
Exception in thread "main" org.h2.jdbc.JdbcSQLException: Cannot parse
"TIMESTAMP" constant "Todd: ""It's Dungeons & Dragons for drunks."""; SQL
statement:
-- row #628 ('2615', '3320534942', 'What''s foursquare?', 'Todd: "It''s
Dungeons & Dragons for drunks."') [22007-182]
At first glance is appears to be separating using quotes, but I don't know
why.
I've checked that the record contains only three tabs and they are in the
right places.
Any ideas?
Thanks
--
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.
