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: Fri, 24 Jan 2014 00:30:01 +0000

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.

Frediano




Archive powered by MHonArc 2.6.24.

Top of Page