[Zope] Maybe non-Zope issue: SQL Server doesn't return table field completely

[Dirk Van.Laanen]

Hello,=20

I have a table with a field 'term' which is a text field, thus up to 255 =
characters.=20
The table was originally an Access database. For reasons of company =
policy,=20
this database has been transported to an SQL Server 6.5 database. The =
old=20
Access database, however, still exists, on the same server als SQL =
Server.=20

If I make a Z ODBC database connection to SQL Server, and perform a =
ZSQL=20
query on the field 'term', only about 120 characters of the field 'term' =
are represented.=20
If I use the Z ODBC database connection to the Access Database (with =
exactly the same=20
data), I get the complete field returned after a query.=20

Does this ring a bell with anybody? Is it just an issue with SQL Server or =
does Zope=20
maybe play a part in it?=20

Cheers everybody,=20

Dirk