[MonetDB-users] SQL BLOB minor issue

Hi, This is probably bad SQL-fu on my part, but you never know :-). I'm trying to insert a 0-byte blob into a table, but that doesn't work for me. The SQL code below fails on the second insert, the database complains about a bad blob syntax. Inserting an implicit NULL into a BLOB colum also fails (the 3th insert), even though inserting an explicit NULL (the fourth one) does succeed. CREATE TABLE testtable ( id INTEGER data BLOB ); INSERT INTO testtable (id, data) VALUES (0, BLOB '00'); INSERT INTO testtable (id, data) VALUES (1, BLOB ''); INSERT INTO testtable (id) VALUES (2); INSERT INTO testtable (id, data) VALUES (2, NULL); Regards, Ronald