Re: About hierarchyid datatype

Just a small update. I just pushed a patch with base support for this
type. Well... base support in the sense FreeTDS does not loose sync
with server when your queries return this type. The type mainly is
encoded similarly to VARBINARY(MAX) beside it has some additional
fields in the metadata to return the CLR type. Obviously some types
are defined by default (like hierarchyid). I don't really know what
should be the support on the client side. Does MS ODBC return this
type as binary or can even convert defined types (probably to string)
?

Frediano

2014-02-03 Frediano Ziglio <[email protected]>:
> 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