Has anyone successfully been able to store a shape/feature into SQL2008 using the WKB from from any of the GetWellKnownBinary functions? I have been told that the values I am getting from the thinkgeo shapes use the right hand rule and SQL2008 requires use of the left hand rule. Any polygons I try to store to the db directly from the thinkgeo functions WKT or WKB error out in SQL.
I wrote a quick little function to convert the WKT from right to left. This seems to work fine so far, but WKT is much slower performance wise and I would really like to use WKB to improve efficiency. Has anyone else handled this?
I tried creating a custom class that reverses the points in the WKT when a shape is saved, then use the reversed WKT to create a new shape. The points in the new shape and the resulting WKB appear to reorganized back to use the right hand rule when the shape is created.