On Wednesday 15 September 2004 05:24 am, David Fetter wrote:
> On Tue, Sep 14, 2004 at 06:37:40PM -1000, Jerome Lyles wrote:
> > On Tuesday 14 September 2004 11:27 am, David Fetter wrote:
> > > On Tue, Sep 14, 2004 at 11:05:46AM -1000, Jerome Lyles wrote:
> > > > I have a small training database: sql_tutorial. It works fine
> > > > but the spacing between the output lines is too much. This is
> > > > the way it looks when I copy and paste from the Konsole to this
> > > > email:
> > > >
> > > > sql_tutorial=> SELECT prod_name FROM Products;
> > >
> > > Is prod_name a char(n) for some large n?
> > >
> > > Cheers,
> > > D
> >
> > char(255)
>
> Well, Don't Do That, Then. TEXT is a great type for storing text.
> VARCHAR(n) is a TEXT with a maximum length constraint, and CHAR(n)
> (fixed length) is pretty nearly obsolete.
>
> Cheers,
> D
This is amazing. Im using a book called 'Teach Yourself SQL in 10 minutes'
with a 2004 copyright and this is the second example of obsolete TEXT type
used in the examples so far.
Jerome