[mapserver-users] Any Known Issues with Blobs in MS SQL and GIS Integration

[Tamas Szekeres]

Steve,

Currently each field to be retrieved is converted to varchar within the sql
query statement in case if the mssql 2008 driver is used. If these fields
are not required, you could probably define a view which doesn't contain
such columns to be retrieved along with that layer.

Best regards,

Tamas



2010/9/9 Lehr, Steven <lehrs at erau.edu>

>  Group:
>
> I have a client that is thinking of using 2 blob type fields in their
> primary table using Microsoft SQL Server.
>
> I was wondering to get some insights on any issues you have experienced
> dealing with joining tables to GIS that have Blob type fields in a table
> being joined too.  Again this is a primary table, and will likely be used in
> almost all Joins from GIS to SQL Server.
>
> Thank you
> Steve Lehr
>
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20100909/a41583e1/attachment.htm>