Is There Support For The HierarchyID Data Type?

[clattan]

I have a SQL Server file table and it contains some columns that have a data type of hierarchyid. Whenever I execute a query that returns one of the hierarchyid columns in the result set, I get an error stating, "not implemented makeGoLangScanType for type 240". I can execute the query inside of the SQL Server Management Studio and it returns the hierarchyid columns as hex values. Is there a way to handle these hierarchyid columns so they are returned raw value is returned, in the same way that SQL Server Management Studio handles them? One of the columns represents a path locator and is the primary key of the file table, so I need a way to reference it as a foreign key in other tables.

[shueybubbles]

@clattan are you trying to scan to interface{} or to []byte ? Or does the target scan type not matter?

[clattan]

@shueybubbles , I've tried string and []byte and get the same result.

[shueybubbles]

@clattan If I'm reading the doc right, it seems you could just cast your value to varbinary in TSQL and it will return the equivalent of what SSMS is doing already. Is that not an option?