Newsgroups: comp.databases
Path: utzoo!utdoe!peter
From: peter@doe.utoronto.ca (Peter Mielke)
Subject: Re: Variable length fields (Summary)
Message-ID: <1991Jan23.212828.28675@doe.utoronto.ca>
Keywords: RDBMS
Reply-To: peter@doe.utoronto.ca (Peter Mielke)
Organization: Dictionary of Old English, University of Toronto
Date: Wed, 23 Jan 1991 21:28:28 GMT


A few days i wrote:
> 
> I'm looking for a relational database system that support fields of
> variable length text. What sort of systems are there available and
> what sort of hard limits are there to the text length?

Well here is a summary of the replies i got:

    Name                Maximum size of variable length field

    Progress            32K
    Sybase              2147K
    Informix            2 gigabytes
    Spires              ?
    Oracle              64K
    Unify               ?
    KnowledgMan, 3.0    ?
    Empress             2147K (the maximum value of int on the machine)

Where ? represents it does have variable length field data type but the
the person who replied didn't know the limit.

Thanks to all who replied...

    dawn <ledbette@watserv1.uwaterloo.ca>
    wlb@pscdev.progress.COM (Warren Bare)
    westbr@vehka.cs.uta.fi (Harri L{nsipuro)
    zhang@cs.sfu.ca
    dberg@cougar.informix.com (David I. Berg)
    ubiquity@cs.utexas.edu (Richard Hoffman)
    "Diana Gregory" <HXKPY%SLACVM.bitnet@ugw.utcs.utoronto.ca>
    Bjorn Engsig <bengsig@dk.oracle.com>
    ewoods@hemel.bull.co.uk (Eoin Woods)
    bjorn@lexis.hi.is (Bjorn Svavarsson)
    dmg@kodiak.unify.com (Dave Glende)
    sequent!sawmill!mdbs!kbc@cse.ogi.edu (Kevin Castleberry)
-- 
Peter Mielke                                    peter@doe.utoronto.ca
Dictionary of Old English Project               utgpu!utzoo!utdoe!peter
University of Toronto