A View Inside My Head

Jason's Random Thoughts of Interest
posts - 71, comments - 168, trackbacks - 12

Knowledge++ [3]

When you write a query that SELECTs a SQL Server 2008 Spatial type, the returned result is a binary value.  Without closely examining the bytes, I just assumed that this was WKB (Well-Known Binary).

Well, as it turns out, the bytes that are returned are simply a serialized version of the .NET object (the UDT has a Write() method that it calls internally to serialize the object in binary).  This is NOT directly compatible with WKB.

My discovery source: http://social.msdn.microsoft.com/Forums/en-US/sqlspatial/thread/40ee9466-d7bf-4340-b295-53217ae5128e

Print | posted on Thursday, January 29, 2009 9:32 AM | Filed Under [ SQL Spatial Knowledge++ ]

Comments have been closed on this topic.

Powered by: