It's a varchar(100) but sites with extensions like ezpersonalfrontpage don't work well with a lot of preferences per user.

ALTER TABLE `ezpreferences` CHANGE `value` `value` TEXT;