wireservice / agate-sql

agate-sql adds SQL read/write support to agate.
https://agate-sql.readthedocs.io
MIT License
18 stars 15 forks source link

MSSQL dialect uses BOOLEAN instead of BIT #31

Closed franksiler closed 5 years ago

franksiler commented 5 years ago

Looking at the code, I'm wondering if this is actually an SQLAlchemy issue, but if I use any of the csvkit commands with -i mssql, I get back out BOOLEAN instead of BIT and have to replace before running in MSSQL. Appreciate any tips.

jpmckinney commented 5 years ago

https://github.com/wireservice/csvkit/issues/1015