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".
Archie
