>>why should i define a column as varchar(20) and should than want to
>>write more data than that?
>>i'd only define it as varchar(20) if i'm sure that 20 chars are enough.
>
> Perhaps there's still some code which still expects longer fields ?
> especially in larger applications w/ many developers/admis this can
> be really dangerous.
well - you assume that i don't know the needs of my app.
i know what i do, so i know why i change a column to varchar(20).