[renehaentjens]

Thanks, Charter, for not giving up on educating me. The articles that you refer to are always interesting and to the point.

My summary on VARCHAR vs. TEXT:
VARCHAR: max 255, no loss of space, trailing spaces removed;
TEXT: in most respects like unlimited VARCHAR, but no DEFAULT value and sorting only uses the first 1024 chars.

My summary on URL length: no limit specified in RFC 1738, in Windows products upto 2083 chars (max32://max2048).

As there is no loss of space anyway, may I suggest to change VARCHARs to 255 in the next release, except where for some reason you count on a truncation to a smaller size?

I understand that checking all possible side-effects of DB corruptions in the PHP code would be a major coding effort.