On Wed, 6 Oct 1999, Archibald Zimonyi wrote:
> On Wed, 6 Oct 1999, Gerald Clark wrote:
>
> > Archibald Zimonyi wrote:
> > >
> > > Hello,
> > >
> > > I'm trying to find a datatype that can contain more then 255 chars.
> > > So far in MySql I've only found the char and varchar datatypes that can
> > > contain any larger amount of text. My problem is that I might add whole
> > > essays into a field.
> > >
> > > Another problem is that it should follow the ANSI-SQL standard so I'm
> > > working on a number of other databases as well. Can anyone give me an
> > > idea on what to do?
> > >
> > > Archie
> > >
> > Try looking in the manual.
> >
> > Both text and blob types can be very large.
> >
>
> Heh, I am aware of the types text and blob, it is just that I really need
> it to follow the ANSI-SQL92 and as far as I can read out from the BNF for
> ANSI-SQL92 I didn't find any text or blob datatypes, which is why I am
> asking. If anyone can show me any other ANSI-SQL92 description where it
> says that text or blob exists then I might breathe easier but until then
> I am afraid I can't use them "just in case".
>
BLOB is SQL3. Don't think you're going to get what you're looking for
with ANSI-SQL92.
--
Bob Kline
mailto:bkline@stripped
http://www.rksystems.com
