Skip to content

Is There Support For SQL Server's hierarchyid data type? #792

Open
@clattan

Description

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 the 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.

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions