False -- Microsoft SQL Server 7.0 supports char and varchar fields up to 8000 characters in size. Anything above that you use text, ntext, or image. To answer the poster's question, Zope/Python strings are _not_ limited to ~256 characters. I have successfully inserted large amounts of data in MSSQL image fields (which is a pain but works), although I don't recall if I ever pushed anything about 256 into a varchar field. If you have access to isql[w], I recommend that you run the query manually and see what happens. -- Alexander Staubo http://www.mop.no/~alex/ "`Ford, you're turning into a penguin. Stop it.'" --Douglas Adams, _The Hitchhiker's Guide to the Galaxy_

-----Original Message----- From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of Larry Luther Sent: 16. juni 1999 16:12 To: Scott Lewis Cc: zope@zope.org Subject: Re: [Zope] sql varchar truncated?

If I recall the varchar type is limited in size (256 chars?) and the "text" (MsSQL?) or "memo" (Access?) type is what is used for large text lengths.

_______________________________________________ Zope maillist - Zope@zope.org http://www.zope.org/mailman/listinfo/zope

(For developer-specific issues, use the companion list, zope-dev@zope.org - http://www.zope.org/mailman/listinfo/zope-dev )