How to specify blob type in MS Access? I have office 2007 installed. I am using jdbc, but this should not matter for the SQL query I am passing. Tried to pass a length to it, or FILE type, did not help.
CREATE TABLE mytable (
[integer] INTEGER not null,
[string] VARCHAR (255),
[datetime] DATETIME,
[boolean] BIT,
[char] CHAR,
[short] SHORT,
[double] DOUBLE,
[float] FLOAT,
[long] LONG,
[blob] BLOB, // does not work
Primary Key ([integer])
)