On Dec 6, 10:30 pm, paulf <[email protected]> wrote: > Hi, > Trying to store a zip file as a blob in h2. Fails with error > "JdbcSQLException: Hexadecimal string with odd number of characters" > After tracing through sequel code to find the problem, it seems that > the h2 adapter cannot handle blobs (column type File) > The sql adapter has some translator code in the connect method. Should > the h2 adapter have something similar? > Regards > Paul F Fraser
It's known to be unsupported in the specs: Supported types should support generic file type (Not yet working on h2) spec/integration/spec_helper.rb:54:in `cspecify' You may be able to retrieve them from the database, but inserting is a problem. If you know what the correct SQL to use, we could probably update the h2 jdbc subadapter to fix it. Jeremy -- You received this message because you are subscribed to the Google Groups "sequel-talk" 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/sequel-talk?hl=en.
