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

Jan Schneider jan at horde.org
Mon Sep 20 09:06:55 PDT 2004


Zitat von Jan Schneider <jan at horde.org>:

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

Oh, and the actual reason was that we don't have a way to restrict a
textarea and thus our longtext form fields to a certain length. I lost huge
parts of my teasers because of this a few times already.

Jan.

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


More information about the dev mailing list