handling of hierachyid datatype

[alanrenmsft]

we are handling it as byte[] data type and as a result, when using Edit Data for a table with this type of columns in Azure Data Studio, we will get an error indicating cannot convert string to byte[].

this issue is found while editing the OrganizationNode column of HumanResources.Employee table in adventureWorks database.

BTW, SSMS handles this data type properly.

[benrr101]

For the record, this was a feature that I didn't really understand at the time so I left it to be worked on later. Though I thought the logic for converting 0x* strings to byte[] was working correctly

[alanrenmsft]

@benrr101 Thanks Ben for the context. I will send a PR shortly.