hi folks, i posted earlier with a problem with ZODBCDA v3.03 and MS SQL Server 7. i have a field that is a VARCHAR length 500. using Zope 1.10.2, this field is truncated to 256 characters on input and output. when i use the same SELECT and INSERT statements with the database clients, everything works as expected. some info in the database help files indicates that the problem might lie with ZODBCDA. versions of the database before 7.0 didn't support VARCHARs greater than 256. it looks like there might still be a limitation, depending on how the database is accessed. this is from the SQL Server Books Online: The osql utility uses the ODBC database application programming interface (API). It is a replacement for the isql command prompt utility that is based on the DB-Library API. Both utilities are provided with Microsoft SQL Server™ version 7.0. The DB-Library API remains at a SQL Server 6.5 level; therefore, applications that depend on DB-Library, such as isql, do not support some SQL Server version 7.0 features. For example, isql cannot access columns defined with the ntext data type and truncates any char, varchar, nchar, or nvarchar columns that are longer than 255 bytes. Except for these limitations in isql, both osql and isql support the same functionality. is something similar in ZODBCDA causing the truncation? if so, should i find another way to do things or is a fix possible? thanks in advance for any help, -scott ----- Scott Lewis Baltic Avenue Productions csl@balticave.com