Tuesday, January 10, 2017

Perl Module DBD::ODBC Unicode Support for Cygwin and Linux

I wrote a Perl program a few years back that scraped data from email messages in order to create a set of RSS feeds. I needed to modify it so that it would get the data directly from a MS-SQL database instead. Windows users running Perl would typically be using ActivePerl, but the environment I’m working on already had Cygwin up and running and is using Perl for other daily processes. Unfortunately, the DBD::ODBC module needed to communicate with the database is broken for 64-bit Cygwin environments. Thus began my journey to get an incompatible Linux-like environment that runs on top of a Windows OS to communicate with a Microsoft database.