When connecting via ODBC to MSSQL Server and try to make query for table which contains one of the folowing datatypes: hierarchyid, geography, geometry, sql_variant, OTL throws an exception:
Unsupported column data type select * from dbo.test Column: 1 / hierarchyid_colName <unknown>
Unsupported column data type select * from dbo.test Column: 1 / geography_colName <unknown>
Unsupported column data type select * from dbo.test Column: 1 / geometry_colName <unknown>
Unsupported column data type select * from dbo.test Column: 2 / sql_variant_colName <unknown></unknown></unknown></unknown></unknown>
Do you plan to add a support for this datatypes in future in OTL library?
Regards.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Good question. Relational databases are not "sexy" any more, they are legacy things. Everything is moving fast (a.k.a. agile) these days, too much time goes into just keeping up with all of the releases of C++ compilers (GNU C++, CLANG, Visual C++). If somebody contributes good enough quality code like it happened with support for geometry for Oracle, I'd be happy to integrate that to OTL.
Cheers,
Sergei
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hello, Sergey.
When connecting via ODBC to MSSQL Server and try to make query for table which contains one of the folowing datatypes: hierarchyid, geography, geometry, sql_variant, OTL throws an exception:
Unsupported column data type select * from dbo.test Column: 1 / hierarchyid_colName <unknown>
Unsupported column data type select * from dbo.test Column: 1 / geography_colName <unknown>
Unsupported column data type select * from dbo.test Column: 1 / geometry_colName <unknown>
Unsupported column data type select * from dbo.test Column: 2 / sql_variant_colName <unknown></unknown></unknown></unknown></unknown>
Do you plan to add a support for this datatypes in future in OTL library?
Regards.
Good question. Relational databases are not "sexy" any more, they are legacy things. Everything is moving fast (a.k.a. agile) these days, too much time goes into just keeping up with all of the releases of C++ compilers (GNU C++, CLANG, Visual C++). If somebody contributes good enough quality code like it happened with support for geometry for Oracle, I'd be happy to integrate that to OTL.
Cheers,
Sergei