[dev] Re: [cvs] commit: jonah/scripts/sql jonah.sql

[Jan Schneider]

Zitat von Chuck Hagenbuch <chuck at horde.org>:

> Quoting Jan Schneider <jan at horde.org>:
>
>>   Log:
>>   Any reason why the description shouldn't be a TEXT column?
>
> Speed if it's ever searchable, storage, etc. - any reason it needs to be
that
> long?

Storage doesn't count, at least not in DBs with dynamic storage allocation
like MySQL. And 255 is really short, but if we make it a VARCHAR(1024), we
could as well make it a TEXT. If searching should matter some time, we need
to search on the body as well.

Jan.

--
Do you need professional PHP or Horde consulting?
http://horde.org/consulting/