Source MSSQL: Connector provides wrong values for some datatypes

[etsybaev]

Found by comprehensive tests #3562

Expected Behavior

A connector should transform source data into an Airbyte datatype without value/meaning losses.

Current Behavior

General source implementation:

• 'binary', 'varbinary'. Returns binary value instead of actual value.

Steps to Reproduce

Short way:

1. Checkout master branch
2. Go to MssqlSourceComprehensiveTest.java and find tests with appropriate types. Use example values from comment to insert to addInsertValues and addExpectedValues
3. Run the test.
4. 💣
   NOTES: To REMEMBER while fixing this bug: Most of the cases would need to be corrected at JdbcUtils, but this is based class that is used by all others JDBC DBs, i.e. all other JDBC DBs will be affected

Severity of the bug for you

High

Airbyte Version

0.24.7-alpha

Connector Version

0.3.7

Origin ticket: #3794