R: About hierarchyid datatype
Frediano Ziglio <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
-------- Messaggio originale -------- Da: Velichko Yuriy <[email protected]> Data: 22/01/2014 21:26 (GMT+00:00) A: FreeTDS Development Group <[email protected]> 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 [email protected] http://lists.ibiblio.org/mailman/listinfo/freetds _______________________________________________ FreeTDS mailing list [email protected] http://lists.ibiblio.org/mailman/listinfo/freetds