in reply to MySQL: BLOB/TEXT vs multiple VARCHAR columns

Unlike many database systems out there, the overhead for BLOB/TEXT fields in MySQL (I normally just use TEXT) is practically none. Other databases (Sybase, IME) allocate at minimum a 2kb page for each TEXT field in a table, even if the TEXT field is empty. Eeek!

  • Comment on Re: MySQL: BLOB/TEXT vs multiple VARCHAR columns