75 次浏览【转载需注明来源】
问题描述:node-adodb 模块 操作 MDB 数据只能用utf16le 格式接收,导致 ole对象 数据 与 实际数据 不符,实际数据为 {1,0,0,1,0,1,0,0} 返回的字节数据会变成 {92,0,117,0,48,0,48,0,48,0,49,0,0,1,0,1,92,0,117,0,48,0,48,0,48,0,48,0}
模块需求:NPMJS 网站显示 mdb-reader 可以读取 ole 格式数据,期望封装此模块,感谢
模块地址:https://www.npmjs.com/package/mdb-reader
github地址:https://github.com/mdbtools/mdbtools
模块数据格式说明:
The data types returned by Table.getData()
depends on the column type. Null values are always returned as null
.
Column Type | JavaScript Type |
---|---|
bigint | bigint |
binary | Buffer |
boolean | boolean |
byte | number |
complex | number |
currency | string |
datetime | Date |
datetimeextended | string |
double | number |
float | number |
integer | number |
long | number |
memo | string |
numeric | string |
ole | Buffer |
repid | string |
text | string |
测试账号