ODBC and WKT

[Frank Warmerdam]

Jeppe Lund Andersen wrote:
> 
> 
> Hello
> 
> Iam running on a windows 2003 server and mapserver 4.8.1 and php 4.4.2
> Iam using a ODBC connection ( "ODBC:test/test at test_dns,v_aktiveflader" )

.... big wkt string ...

> When I use "$Layer->queryByAttributes($ID_navn, $ID_value, 
> $ResultType);" to get the specifik shape
> it returns 0
> if I change the WKT streng to
> 
> POLYGON((501982.449393967 6268525.27980791, 501972.653330944 
> 6268522.51037162, 501956.796572362 6268519.5209801))
> 
> It works fine.
> 
> So is there a limit to how long the WKT string can be ?
> or a work around so I can load long WKT strings

Jeppe,

I believe older versions of GDAL/OGR had problem with long text attributes
via ODBC.  What version of GDAL/OGR are you using?  Can you test the same
ODBC connection using the ogrinfo from FWTools 1.0.9?

   http://fwtools.maptools.org/

If the problem persists I would suggest submitting a bug report.  It would
be very helpful if you could reproduce the problem with a more portable
database format, such as MS Access so you could submit a database with the
bug report.  I don't run SQL Server and can't easily test stuff related to
it.

Best regards,
-- 
---------------------------------------+--------------------------------------
I set the clouds in motion - turn up   | Frank Warmerdam, warmerdam at pobox.com
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush    | President OSGeo, http://osgeo.org