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.
