How to specify blob type in MS Access?

3
votes

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])
)
1
ms-accessblob

1 Answers

3
votes

Use LONGBINARY as the data type for the blob field in your DDL statement. See Field type reference - names and values for DDL, DAO, and ADOX