Current 'bookings_resources' table desc set field 'description' as a VARCHAR(255).

I think it's too short. Should be, minimun 1024.

Note from MySQL documentation:
Values in VARCHAR columns are variable-length strings. The length can be specified as a value from 0 to 255 before MySQL 5.0.3, and 0 to 65,535 in 5.0.3 and later versions.

Comments

Anonymous’s picture

Anonymous (not verified) commented

Well, I'd strongly dislike setting a VARCHAR to more then 255 characters in length... backward compatibility or compatiblity to other databases are important factors in a CMS.

Setting this to a TEXT-field would be possible – but then searching in the description field would be much slower.

rodrigobb’s picture

rodrigobb commented

I now you could disagree, that's why I pasted the lines from the MySQL doc ;)

I just pointed that 255-length descriptions are very short (IMHO). You are the module leader, you decide.

Anonymous’s picture

Anonymous (not verified) commented

I agree that it's short (actually it's more with 3.x ;) ) … but Drupal 6 requires "MySQL 4.1 or higher" – and thus I don't want to use "5.x only features". I'll think about switching to a text-field :)