----- Original Message ----- From: "Richard Davey" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, March 01, 2004 11:02 AM Subject: Re: Type TEXT
> Hello Jim, > > Monday, March 1, 2004, 5:44:22 PM, you wrote: > > JM> Are the TEXT column types padded out to their max length by spaces? > > No, they're variable length and at a maximum of 65KB per row, be > thankful of this! A 30 character string will take up 32 bytes for > example. Thanks. What (if any) difference is there then be between a varchar(255) and a tinytext column? And what disadvantages are there be in using columns of type text, rather than varchar(n)? Are there performance penalties? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]