improvement.
Of course, if you have other variable length columns in your table,
MySQL will be stupid and change your CHAR to VARCHAR, thinking it's
"helping" you. :-(
Matt
- Original Message -
From: "Hassan Shaikh"
Sent: Sunday, January 11, 2004 7:04 AM
Sub
If the data is 10-char in length always, CHAR is better performance-wise.
- Original Message -
From: "Hassan Shaikh" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, January 11, 2004 6:34 PM
Subject: Which one is better: CHAR or VARCHAR?
Hi,
I've
Char is more efficient when selecting but less efficient when storing (wastes space).
It is a trade off so there really isn't a "right" answer. Do some experimenting and
see what works best for you.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Hi,
I've a column of type VARCHAR(10) where I know the data would be 10-char in length -
always. Apart from the fact that VARCHAR saves space as compared to CHAR, is there any
performance benefit? If yes, is it significant enough?
Thanks.
Hassan