Are the TEXT column types padded out to their max length by spaces?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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.
--
Best regards,
Richard
Jim McAtee [EMAIL PROTECTED] wrote:
Are the TEXT column types padded out to their max length by spaces?
No. It's variable-length column type.
http://www.mysql.com/doc/en/Storage_requirements.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email
- 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
handles them however, but I couldn't tell you what.
JM And what disadvantages are there be in using columns of type text, rather
JM than varchar(n)? Are there performance penalties?
If your data will always fit into 255 characters (or less) then use a
varchar, if you always know the exact length
PROTECTED]
Sent: Monday, March 01, 2004 5:32 PM
To: Jim McAtee
Cc: [EMAIL PROTECTED]
Subject: Re[2]: Type TEXT
Hello Jim,
Monday, March 1, 2004, 8:58:51 PM, you wrote:
JM Thanks. What (if any) difference is there then be between a
varchar(255) and
JM a tinytext column?
On the surface nothing I