Re: About hierarchyid datatype

2014-01-24 Frediano Ziglio <[email protected]>:
>
> 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.
>


Hi,
  I'll correct myself, this type was added in mssql 2008. Never
used... beside point 2 all others remains.

Frediano