Re: About hierarchyid datatype

Il 22/gen/2014 21:27 "Velichko Yuriy" <[email protected]> ha scritto:
>
> 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!
>

Well, there are actually a couple of problems.

1. It's not easy to add a new type;
2. We do not fully even support 2008 while this type is 2012;
3. Dblib has to be extended to support new types.

Frediano