Nevermind... the file wasn't being flushed, so the line was truncated.
On Friday, March 14, 2014 6:26:43 PM UTC-7, Brian Craft wrote: > > Is there a way to csvread a varbinary column? I tried dumping it as hex > (from another source), but h2 barfs about half way through. It seems to be > doing the hex conversion, but then exits with > > Hexadecimal string with odd number of characters: > "444C0000444C0000444C0000444C0000444C0000444C000043B0800043B0800043B0800043B0800043B0800043B080004352000043520" > > The actual line in the file is longer. I'm not sure why it's truncated in > the error message. Here's the full line (with id in first column): > > 88267559 > > 444C0000444C0000444C0000444C0000444C0000444C000043B0800043B0800043B0800043B0800043B0800043B0800043520000435200004352000043520000435200004352000044888000420400004204000042040000420400004204000042040000440B0000440B0000440B0000440B0000440B0000440B00004170000041700000417000004170000041700000417000004418800044188000441880004418800044188000441880004488A0004488A00043ED800043ED800043ED800043ED800043ED800043ED8000443B0000443B0000443B0000443B0000443B0000443B00004488C0004488C0004488C0004488C0004488C0004488C0004406C0004406C0004406C0004406C0004406C0004406C00044284000442840004469400044694000446940004469400044694000446940004404C0004404C0004404C0004404C0004404C000445B0000445B0000445B000043710000437100004371000043710000437100004371000042B6000042B6000042B6000042B6000042B6000042B60000437F0000437F0000437F0000 > > > It reads 8969 lines, all the same length, before choking on this one. > > The fields are defined as > `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY > `expScores` VARBINARY(400) NOT NULL > > > > -- 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.
