[Sqlalchemy-tickets] Issue #3973: xml datatype not supported for MS SQL Server (zzzeek/sqlalchemy)

[David J. <iss...@bi...>]

New issue 3973: xml datatype not supported for MS SQL Server
https://bitbucket.org/zzzeek/sqlalchemy/issues/3973/xml-datatype-not-supported-for-ms-sql

David Johansen:

This error is output:
```
/usr/src/app/connectrunner/venv/lib/python3.6/site-packages/sqlalchemy/dialects/mssql/base.py:1926: SAWarning: Did not recognize type 'xml' of column 'WatchXMLData'
(type, name))
Can't generate DDL for NullType(); did you forget to specify a type on this Column?
```

It appears that it should be mapped to `LONGVARCHAR` based on the documentation:
https://docs.microsoft.com/en-us/sql/t-sql/xml/xml-transact-sql
https://documentation.progress.com/output/DataDirect/DataDirectCloud/index.html#page/queries/microsoft-sql-server-data-types.html