>Ok I've just done a test here on Linux and did the following: > >shp2pgsql arc testtable -W LATIN1 > arc.sql >psql -d postgis -f arc.sql > >Followed by: > >SELECT astext(the_geom) FROM testtable where gid = 7; >SELECT astext(the_geom) FROM testtable; > >(Both of these look fine) > >Then: > >ALTER TABLE testtable ADD COLUMN testfield text; >UPDATE testtable SET testfield = astext(the_geom);
>SELECT testfield FROM testtable; >Everything looks fine here. Can you confirm that these steps give you >the problem? Also, which versions of PostGIS/PostgreSQL are you using? >Please send the output of: >SELECT version(); >SELECT postgis_full_version(); >Kind regards, >Mark. "POSTGIS="1.1.5" GEOS="2.2.3-CAPI-1.1.1" PROJ="Rel. 4.4.9, 29 Oct 2004" USE_STATS" "PostgreSQL 8.1.5 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2 (mingw-special)" OS Windows XP PRO Sorry value in the field is ok :) When I copy and past this value to notepad all looks ok. I think the issue is in ODBC driver. Thak you for your help. I`ll ask for this problem on PostgreSQL ODBC mailing list _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
