Backend Types supported#
This table give a comprehensive list of the SQL Types that are expected to be supported by the database backends. If the type is not supported then the backend will have to emulate the behavior described here.
The columns are in the following order:
The SQL type [1] representing the field
The python type expected on input
The python type received on output
None
will represent the NULL
value and vice versa, it can be used as
input or output for any SQL type.
SQL Type |
Python input type |
Python output type |
---|---|---|
|
bool |
bool |
|
int |
int |
|
int |
int |
|
int |
int |
|
float / int |
float |
|
float / int |
float |
|
||
|
str |
str |
|
str |
str |
|
||
|
datetime.datetime without microseconds [2] |
datetime.datetime without microseconds [2] |
|
||
|
||
|
||
|
bytes |
bytes |
|
dict |
dict |