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!
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.