freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- From: Frediano Ziglio <freddy77 AT gmail.com>
- To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
- Subject: Re: [freetds] About hierarchyid datatype
- Date: Tue, 4 Feb 2014 22:08:25 +0000
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 <freddy77 AT gmail.com>:
> 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
-
Re: [freetds] About hierarchyid datatype,
Frediano Ziglio, 02/03/2014
-
Re: [freetds] About hierarchyid datatype,
Frediano Ziglio, 02/04/2014
-
Re: [freetds] About hierarchyid datatype,
Velichko Yuriy, 02/05/2014
-
Re: [freetds] About hierarchyid datatype,
Frediano Ziglio, 02/05/2014
-
Re: [freetds] About hierarchyid datatype,
Frediano Ziglio, 02/10/2014
- Re: [freetds] About hierarchyid datatype, Frediano Ziglio, 02/11/2014
-
Re: [freetds] About hierarchyid datatype,
Frediano Ziglio, 02/10/2014
-
Re: [freetds] About hierarchyid datatype,
Frediano Ziglio, 02/05/2014
-
Re: [freetds] About hierarchyid datatype,
Velichko Yuriy, 02/05/2014
-
Re: [freetds] About hierarchyid datatype,
Frediano Ziglio, 02/04/2014
Archive powered by MHonArc 2.6.24.