如何在MS Access中指定Blob类型? [英] How to specify blob type in MS Access?

问题描述

如何在MS Access中指定Blob类型?我已经安装了Office 2007.

我正在使用jdbc，但这与我传递的SQL查询无关.尝试向其传递长度(或FILE类型)没有帮助.

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])
)

推荐答案

在您的DDL语句中，将LONGBINARY用作blob字段的数据类型.请参见字段类型引用-DDL，DAO和ADOX的名称和值

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

这篇关于如何在MS Access中指定Blob类型?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！