Re: [Zope] Maybe non-Zope issue: SQL Server doesn't return tablefield completely

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

Hallo Jon, 

>Do you have physical access to the SQL Server?  If so, run one of the
>SQL Server native utilities to browse the table and verify the integrity
>of the "term" field.  IIRC, for SQL Server 6.5 you could use the
>"Enterprise Manager" or a utility named "isqlw" to query a database.
>Most likely the field was somehow truncated during the transfer.

Yes, I could examine the field in SQL Server. It is obvious the field wasn't truncated. 
It seemed a sound suggestion though. Someone has suggested a corrupt (SQL Server) 
driver could be responsible for bad transmission of correct data to Zope, though I 
wouldn't know what action that would require (or how to establish that for a fact). 

Thanks for your help, 
cheers, Dirk


>>> Jon Erickson <jon.erickson@xxxxxxxxxxxxxx> 05/01/02 04:14pm >>>
On Wed, 2002-05-01 at 08:50, Dirk Van.Laanen wrote:
> 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? 


Jon 




_______________________________________________
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 )