Re: Silent column changes and Indexes

2001-02-24 Thread Sinisa Milivojevic
Mark Chalkley writes: > According to the MySQL manual (section 7.7.1), CHAR columns defined to be greater >than 3 chars in length are converted to type VARCHAR. I understand the space >efficiency issues involved here, but when the column is used in an index, doesn't >that impose a performa

Silent column changes and Indexes

2001-02-23 Thread Mark Chalkley
According to the MySQL manual (section 7.7.1), CHAR columns defined to be greater than 3 chars in length are converted to type VARCHAR. I understand the space efficiency issues involved here, but when the column is used in an index, doesn't that impose a performance penalty? Or does MySQL han