<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1170" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><BR></DIV>
<DIV><FONT face=Arial size=2>I have the next problem. I modify via
PHP/Mapscript the data portion of a .map file. The resulting SQL
is:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV>SELECT
nivel_imp::text,asbinary(force_collection(force_2d(the_geom)),'NDR'),OID::text
from (select localidad_plano.oid as oid, localidad_plano.the_geom as the_geom,
web_implem_grado.grado as nivel_imp from localidad_plano, inf_institucion,
web_implem, web_implem_grado WHERE localidad_plano.codigopostal =
bpchar(inf_institucion.codigo_postal,10) AND inf_institucion.id_institucion =
web_implem.id_institucion AND web_implem.pampa = web_implem_grado.grado ) AS foo
WHERE the_geom && setSRID('BOX3D(-73.597264 -57.9529488695652,-53.562864
-18.8021391304348)'::BOX3D, 4326 )</DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>but i have the next error when i try to run this
sql in pgadmin</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>"value too long for type character(6).</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I'm using PostgreSQL 7.2.3 and PostGIS 0.7.3 in a
win2k machine.</FONT></DIV>
<DIV><FONT face=Arial size=2>In other machines with the same sql run
properly.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Any idea??</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Regards</FONT></DIV>
<DIV><FONT face=Arial size=2>Osca</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV></BODY></HTML>