About hierarchyid datatype
Velichko Yuriy <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <CAN=WvWsys3ttCP1_JEHh9XSBX0HBGuNPSubyP9ciCQjf43GoiQ@mail.gmail.com> |
Now the method:
dbcoltype()
returns SYBBINARY for hierarchyid datatype. in result no way to cast such
data to the string like '/1/2'
The CAST function can convert hierarchyid to varchar:
http://technet.microsoft.com/en-us/library/ms187928(v=sql.105).aspx
May be is not so hard to implement the proper behaviour for dbcoltype()
and dbconvert() functions to have ability to fetch data in "readable" form?
Thanks!
--
Best Regards!