freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- From: Velichko Yuriy <velichko.yuriy AT gmail.com>
- To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
- Subject: [freetds] About hierarchyid datatype
- Date: Wed, 22 Jan 2014 23:26:50 +0200
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!
--
Best Regards!
-
[freetds] About hierarchyid datatype,
Velichko Yuriy, 01/22/2014
- Re: [freetds] About hierarchyid datatype, Frediano Ziglio, 01/23/2014
Archive powered by MHonArc 2.6.24.