[Zope] sql varchar truncated?

[Alexander Staubo]

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