[Zope] Re: Truncation Reading from ODBC

[Derrick 'dman' Hudson]

On Fri, Aug 08, 2003 at 10:02:19AM +0200, Stefan Drees wrote:
| On Fri, Aug 08, 2003 at 04:04:14AM +0200 - a wonderful day 
| 					- Jerry Westrick wrote:
[...]
| > When I read a column with 20,000+ characters I only get the first 
| > 8194 characters.  
[...]
| What about PostgreSQL. Which Version? 
| A short glimpse at the online postgresql manual - namely at
| http://www.postgresql.org/docs/7.2/static/datatype-character.html
| yields: 
| """Note: Prior to PostgreSQL 7.2, strings that were too 
| long were silently truncated, no error was raised. 
| """

What data type?  I suspect the above quote refers to inserting a
VARCHAR.  I know that the 'TEXT' type allows up to 2GB.

Also check the settings of both the zope adapter and the ODBC driver.
ISTR a buffer limit setting somewhere (but I haven't worked with any
of that recently).

HTH,
-D

-- 
Love is not affectionate feeling, but a steady wish for the loved
person's ultimate good as far as it can be obtained.
        --C.S. Lewis
 
http://dman13.dyndns.org/~dman/
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 240 bytes
Desc: not available
Url : http://lists.zope.org/pipermail/zope/attachments/20030808/50415c37/attachment.bin