search

zillow / ctds

Python DB-API 2.0 library for MS SQL Server
MIT License
83 stars 12 forks source link

Are there plans to support geometry data types? #97

Closed dfox-rms closed 1 year ago

dfox-rms commented 1 year ago

Are there plans to support geometry data types? When I query a table with a geometry column named 'SHAPE', I receive the following error: _tds.NotSupportedError: unsupported type 240 for column "SHAPE"

CTDS has been a very useful for my work. Thanks!

joshuahlang commented 1 year ago

That would require support in FreeTDS, which is the underlying library used by cTDS for the majority of the TDS protocol implementation. Once FreeTDS supports the type (see here for the currently supported types) adding support in cTDS would be possible.

dfox-rms commented 1 year ago

Fair point! Thanks for clarifying the underlying issue.