<!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.6000.16735" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV dir=ltr align=left><SPAN class=043030316-18122008><FONT face=Arial
color=#0000ff size=2>Not absolutely sure, but I think its a limit in the
spec. I think fields > 254 are considered to be memo fields in the dbf
world and so would be put in a .dbt.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=043030316-18122008><FONT face=Arial
color=#0000ff size=2>Its been a while since I've done any DBase or Foxpro
programming so my memory could be wrong.</FONT></SPAN></DIV>
<DIV><SPAN class=043030316-18122008><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=043030316-18122008><FONT face=Arial color=#0000ff size=2>I've
never actually seen .dbt files included with ESRI shape files, so I assume ESRI
discarded that side of the spec. If its allowed, then we probably should
implement it.</FONT></SPAN></DIV>
<DIV><SPAN class=043030316-18122008><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=043030316-18122008><FONT face=Arial color=#0000ff size=2>Hope
that helps,</FONT></SPAN></DIV>
<DIV><SPAN class=043030316-18122008><FONT face=Arial color=#0000ff
size=2>Regina</FONT></SPAN></DIV>
<DIV><SPAN class=043030316-18122008><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=043030316-18122008><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><BR></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of
</B>Gustavo Ces<BR><B>Sent:</B> Thursday, December 18, 2008 10:53
AM<BR><B>To:</B> PostGIS Users Discussion<BR><B>Subject:</B> [postgis-users]
pgsql2shp cuts varchar fields<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV><FONT face=Arial size=2>Hi all,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2> maybe this is an old issue...
I´m trying to export to shapefile some geometries, but in the result shapefile
varchar fields greater than 255 are cutted at this point. I´ve got alternatives
but i´d like to know : is there any method to export those fields directly with
pgsql2shp or is it a shapefile-format or pgsql2shp limit?</FONT></DIV>
<DIV><FONT face=Arial size=2> Thanks in advance,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Gus</FONT></DIV></BODY></HTML>
<HTML><BODY><P><hr size=1></P>
<P><STRONG>
The substance of this message, including any attachments, may be confidential, legally privileged and/or exempt from disclosure pursuant to Massachusetts law. It is intended solely for the addressee. If you received this in error, please contact the sender and delete the material from any computer.
</STRONG></P></BODY></HTML>
<P><hr size=1></P>
<P><STRONG><font size="2" color="339900"> Help make the earth a greener place. If at all possible resist printing this email and join us in saving paper. </p> <p> </font></STRONG></P>