[mythtv] channel.channum too narrow

Jeremy Muhlich jmuhlich at bitflood.org
Thu Jan 19 04:56:20 UTC 2006


On Wed, 2006-01-18 at 12:24 -0800, Bruce Markey wrote:
> Since Tom already had an example with 8 characters, I set it to 10.

A varchar(5) column and a varchar(255) column that hold the string
"102#10" both take the EXACT SAME amount of space (7 bytes).  Am I
missing some good reason for limiting the length of that column or can
it just be cranked all the way to 255?

For that matter, I feel almost all varchars should be defined as (255).
There are very few good reasons for imposing a shorter limit, and a
future of sweet bugs like this one arguing strongly against it.


 -- Jeremy




More information about the mythtv-dev mailing list