12 Dec
2006
12 Dec
'06
11:57 a.m.
On 2006-11-23 14:51, Ronald Oussoren wrote:
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);
Can you make a bugreport out of this? Thanks. -- Sjoerd Mullender