﻿<?xml version="1.0" encoding="UTF-8"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/"><channel><title>StrataFrame Forum » StrataFrame Application Framework - V1 » Issues  » sql server 2008 geography data type</title><generator>InstantForum 2017-1 Final</generator><description>StrataFrame Forum</description><link>http://forum.strataframe.net/</link><webMaster>StrataFrame Forum</webMaster><lastBuildDate>Fri, 22 May 2026 11:27:33 GMT</lastBuildDate><ttl>20</ttl><item><title>sql server 2008 geography data type</title><link>http://forum.strataframe.net/FindPost30904.aspx</link><description>I have a table that have a geography column, when try to update this column (existent data) the next exception shows:&lt;br/&gt;&lt;br/&gt;&lt;div&gt;{"An error occurred while saving an the data to the server."}&lt;br/&gt;&lt;br/&gt;&lt;div&gt;InnerException:&lt;div&gt;{"Operand type clash: sql_variant is incompatible with geography"}&lt;br/&gt;&lt;br/&gt;&lt;div&gt;I Can't use this data type (geography)with sql server 2008 r2 tables that was serialized with&amp;nbsp;strataframe&amp;nbsp;BOM?&lt;br/&gt;&lt;br/&gt;&lt;div&gt;In that case I can use a point data or another recomeended data type or have to use 2 fields 1 for latitude and another for longitude?&amp;nbsp;&lt;br/&gt;&lt;br/&gt;&lt;div&gt;Thanks</description><pubDate>Thu, 09 Feb 2012 12:56:50 GMT</pubDate><dc:creator>Fabian R Silva, -</dc:creator></item></channel></rss>