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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]