Database Binary Primary Key how to retain full length with out SQL CONVERT Function

[kosie-snyman]

Good day

I am not getting the correct results when importing Data from a database that use Binary field type as a primary key.

Server Collation = Latin1_General_CI_AS

Using Alteryx Connect In-DB to extract data for the Field of which StatsdbbN.oid field is the Primary Key set as Binary (6) in SQL with Server Collation = Latin1_General_CI_AS.

I get the following results

The Primary Key should be 14 characters long, as displayed in the SSMS query below

I can resolve the issue using File Input and then CONVERT the Binary field to VARCHAR 14, but would like to not do that. Any advice on how to resolve will be appreciated.

[Nay376]

Hi Kosi-Snyman, did you ever resolve this? I have the same issue and was hoping you could help advise a resolution