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

["Dirk Van.Laanen" <Dirk.Van.Laanen@xxxxxxxxxxxx>]

Hello, 

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

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

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

Cheers everybody, 

Dirk





_______________________________________________
Zope maillist  -  Zope@xxxxxxxx
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists -
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )