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 _______________________________________________ mythtv-dev mailing list [email protected] http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev
