On Wed, 6 Oct 1999, Bob Kline wrote:
> 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
>
Yep, that was what I was afraid of.
Thanks for the answers.
Archie
