Data types

The following table describes the supported Firebird 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.

Firebird data type	Type code	Python data type
BOOLEAN	401	bool
SMALLINT	402	int
INTEGER	403	int
BIGINT	404	int
FLOAT	405	float
DOUBLE	406	float
DECIMAL	407	float
NUMERIC	408	float
INT128	419	float
DECFLOAT16	420	float
DECFLOAT34	421	float
DATE	409	datetime.date
TIME	410	datetime.time
TIMESTAMP	411	datetime.datetime
TIME WITH TIME ZONE	422	datetime.time
TIMESTAMP WITH TIME ZONE	423	datetime.datetime
TIME [WITHOUT TIME ZONE]	424	datetime.time
TIMESTAMP [WITHOUT TIME ZONE]	425	datetime.datetime
CHAR	412	str
VARCHAR	413	str
TEXT	417	str
CHARBIN	414	binary
VARCHARBIN	415	binary
BLOB	416	bytes
ARRAY	418	array.array

Request Support

Python Connectors Forum

Provide Feedback