Python and OpenText Analytics Database data types
The OpenText™ Analytics Database Python SDK converts native database data types into the appropriate Python data types.
The OpenText™ Analytics Database Python SDK converts native database data types into the appropriate Python data types. The following table describes some of the data type conversions. Consult the Python SDK for a complete list, as well as lists of helper functions to convert and manipulate these data types.
For information about SDK support for complex data types, see Complex Types as Arguments and Return Values.
| OpenText™ Analytics Database Data Type | Python Data Type |
|---|---|
| INTEGER | int |
| FLOAT | float |
| NUMERIC | decimal.Decimal |
| DATE | datetime.date |
| CHAR, VARCHAR, LONG VARCHAR | string (UTF-8 encoded) |
| BINARY, VARBINARY, LONG VARBINARY | binary |
| TIMESTAMP | datetime.datetime |
| TIME | datetime.time |
| ARRAY |
list Note: Nested ARRAY types are also converted into lists. |
| ROW |
collections.OrderedDict Note: Nested ROW types are also converted into collections.OrderedDicts. |