> OK, you confused me. How can 16 be bigger than 16? For character-based > fields, the number in the parentheses shows the length of the field, > does it not? The first part, the "text" or "char" or "varchar" or ..., > tells the engine what kind of data a field will contain.
> How can TEXT(16) hold more data than VARCHAR(16) ? I'm not sure how the (16) is used on a TEXT field. MS SQL has TEXT fields and VARCHAR fields. A VARCHAR(16) in MSSQL would be the same as a VARCHAR(16) in MySQL. But in my MSSQL database I have data with thousands of characters in a TEXT(16) field. -Ryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]