Skip to Content.
Sympa Menu

freetds - Re: [freetds] About hierarchyid datatype

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Frediano Ziglio <freddy77 AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] About hierarchyid datatype
  • Date: Mon, 3 Feb 2014 14:57:56 +0000

2014-01-24 Frediano Ziglio <freddy77 AT gmail.com>:
>
> Il 22/gen/2014 21:27 "Velichko Yuriy" <velichko.yuriy AT gmail.com> 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




Archive powered by MHonArc 2.6.24.

Top of Page