Skip to Content.
Sympa Menu

freetds - [freetds] R: 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: [freetds] R: About hierarchyid datatype
  • Date: Fri, 24 Jan 2014 00:19:51 +0000



-------- Messaggio originale --------
Da: Velichko Yuriy <velichko.yuriy AT gmail.com>
Data: 22/01/2014 21:26 (GMT+00:00)
A: FreeTDS Development Group <freetds AT lists.ibiblio.org>
Oggetto: [freetds] About hierarchyid datatype

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 mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds


  • [freetds] R: About hierarchyid datatype, Frediano Ziglio, 01/23/2014

Archive powered by MHonArc 2.6.24.

Top of Page