1) Should BYTEA columns accept ASCII input if quoted?
CREATE CACHED TABLE PUBLIC.TEST (VAL BYTEA)
then
INSERT INTO test (val) VALUES ('29/10')
throws
org.h2.jdbc.JdbcSQLException: Hexadecimal string with odd number of
characters: 29/10;
Can it be changed to accept this on presumption that the string is an
ASCII one? I believe this is accepted by PG and some others.
2) I also tried
INSERT INTO registry (val) VALUES ('12345') which is considered hex
would be legal (even if missing the leading 0x) equivalent to 012345
(0x012345)
3) INSERT INTO registry (val) VALUES ('0x012345') throws:
Hexadecimal string contains non-hex character: 0x012345
4) (I don't know if this should be accepted) INSERT INTO registry
(val) VALUES (0x012345) throws:
Hexadecimal string with odd number of characters: 74565;
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
