[mythtv] channel.channum too narrow
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.
More information about the mythtv-dev