Maybe non-Zope issue: SQL Server doesn't return table field completely
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
participants (1)
-
Dirk Van.Laanen