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
--
David Fetter david@fetter.org http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vote!