Received: by 10.66.84.41 with SMTP id v9mr509541pay.43.1346273047239;
        Wed, 29 Aug 2012 13:44:07 -0700 (PDT)
X-BeenThere: pyodbc@googlegroups.com
Received: by 10.68.141.75 with SMTP id rm11ls6901652pbb.6.gmail; Wed, 29 Aug
 2012 13:44:06 -0700 (PDT)
Received: by 10.68.218.226 with SMTP id pj2mr656886pbc.19.1346273046736;
        Wed, 29 Aug 2012 13:44:06 -0700 (PDT)
Date: Wed, 29 Aug 2012 13:44:06 -0700 (PDT)
From: ce...@aliandcedar.com
To: pyodbc@googlegroups.com
Message-Id: <28fc805c-3c15-4424-882f-8e27a054a0db@googlegroups.com>
Subject: long text field truncated at 1023 chars
MIME-Version: 1.0
Content-Type: multipart/mixed; 
	boundary="----=_Part_17_30499945.1346273046078"

------=_Part_17_30499945.1346273046078
Content-Type: multipart/alternative; 
	boundary="----=_Part_18_1524754.1346273046078"

------=_Part_18_1524754.1346273046078
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit

pyodbc 3.06 talking to filemaker ODBC driver 11.3.81

I have a text field that contains a string >7000 characters. When I do 
something like:

curs.execute("SELECT my_text_field FROM test_table WHERE test_table.id = 1")

 

> for result in curs:
>     print result



The result I get is just what I'm looking for except truncated to the first 
1023 characters!

I'm sure the ODBC driver and DNS are fine because I can 
successfully retrieve the entire field using php and odb_connect. To me, 
that means it must be a pyodbc issue. Any suggestions?

Thanks!



------=_Part_18_1524754.1346273046078
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: quoted-printable

pyodbc 3.06 talking to filemaker ODBC driver 11.3.81<div><br></div><div>I h=
ave a text field that contains a string &gt;7000 characters. When I do some=
thing like:</div><div><br></div><blockquote class=3D"gmail_quote" style=3D"=
margin: 0px 0px 0px 0.8ex; border-left-width: 1px; border-left-color: rgb(2=
04, 204, 204); border-left-style: solid; padding-left: 1ex; ">curs.execute(=
"SELECT my_text_field FROM test_table WHERE&nbsp;test_table.id =3D 1")</blo=
ckquote><div>&nbsp;</div><blockquote class=3D"gmail_quote" style=3D"margin:=
 0px 0px 0px 0.8ex; border-left-width: 1px; border-left-color: rgb(204, 204=
, 204); border-left-style: solid; padding-left: 1ex; ">for result in curs:<=
br>&nbsp; &nbsp; print result</blockquote><div><br></div><div><br></div><di=
v>The result I get is just what I'm looking for except truncated to the fir=
st 1023 characters!</div><div><br></div><div>I'm sure the ODBC driver and D=
NS are fine because I can successfully&nbsp;retrieve&nbsp;the entire field =
using php and odb_connect. To me, that means it must be a pyodbc issue. Any=
 suggestions?</div><div><br></div><div>Thanks!</div><div><br></div><div><br=
></div>
------=_Part_18_1524754.1346273046078--

------=_Part_17_30499945.1346273046078--