Hi, When supplying binary/literal values in raw SQL (not using PreparedStatement), the H2 driver or database attempts parse them as a hex value; 'abcd' is parsed as 0xAB, 0xCD instead of 0x61 0x62 0x63 0x64.
However as I recall the SQL spec saya literal binary data should be one-to-one ascii/iso8859-1 (0-255) char-equivs (including \0); the only exception being 0x27, which must be doubled of course.. My question is, is there any way now (URL argument etc) to switch into the ascii-encoded binary mode? Which would also behave like to PG and Mysql... (please pardon that this topic has been discussed perhaps 1 year ago however I am unable to find it in the list (do topics expire?)... I am also hoping a solution is now available in H2) Thanks, Ken -- 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.
