search

keboola / db-extractor-mssql

MIT License
1 stars 2 forks source link

Support GEO datatype #106

Open padak opened 5 years ago

padak commented 5 years ago

Client asked us to add support for geography datatype. Everything is precisely described in Zendesk ticket https://keboola.zendesk.com/agent/tickets/9731

We need to do GeoColumn.ToString() on the top of it. Without it, data looks like 

"Ê��Ël�°ı�I@eT�∆›¯,@"
"Ê��ôG˛`‡óH@U˙    g∑ö0@"
"Ê��  6Æ�◊ôH@îK„�^°0@"
"Ê��7S!�âõH@Ωåbπ•ô0@"

After conversion, data looks like

POINT (15.775277 50.038124)
POINT (15.589785 49.394642)
POINT (15.801574 49.940113)
POINT (17.248199 49.57476)