long text field truncated at 1023 chars

[ce...@aliandcedar.com]

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!

[robin.t...@googlemail.com]

hi, did you manage to solve this? tried casting to nvarchar(max) but ... well here I am still

cheers