Although I know nothing about C I imagine this is because the 'type' column can contain
all the possible values from an ENUM or SET field.
James Harvard
At 10:30 am +0000 6/7/06, SciBit MySQL Team wrote:
>Since a couple of recent stable versions back (and more recently, MySQL 5.0.22), MySQL
> has been returning the column length (C API) of the 'Type' column of a "show columns
> from.." statement as being 196605 (almost 192KB), when this column only really contains
> data in the region of 10 bytes