|
Python Connector for Microsoft Access Data types - Python Connector for Microsoft Access |
|
|
|
Python Connector for Microsoft Access Data types - Python Connector for Microsoft Access |
|
The following table describes the supported Microsoft Access data types and their mapping to the Python data types. The type codes returned in the description cursor attribute can be used in the addtypecast() cursor method.
| Access data type | Type code | Python data type |
|---|---|---|
|
SHORT TEXT |
5001 |
str |
|
LONG TEXT |
5032 |
str |
|
BYTE |
5008 |
int |
|
INTEGER |
5009 |
int |
|
LONG INTEGER |
5010 |
int |
|
LARGE NUMBER |
5013 |
int |
|
SINGLE |
5015 |
float |
|
DOUBLE |
5016 |
float |
|
NUMBER |
5021 |
float |
|
CURRENCY |
5018 |
float |
|
DATE/TIME |
5024 |
datetime.datetime |
|
DATE/TIME EXTENDED |
5025 |
datetime.datetime |
|
YES/NO |
5027 |
bool |
|
OLE OBJECT |
5031 |
binary |