I am assuming SQL Server is MSSQL. Just checked my DBI.pm book under DBD:Sybase. on the connect, you can pass "charset", this will auto-convert the character set for you. (unfortunately it doesn't list the available charsets).

If you are using FreeTDS libs, I suspect this would still be valid.

Not sure how helpful this is, but perhaps it's a start. good luck!!