Correction: VARCHAR(1024) will use only the space needed for actual data, you were writing about CHAR datatype... OTOH, maximum size of index entry is 255 bytes, so you cannot index VARCHAR(1204) either, but I doubt it is necessary. I guess you had full text search in mind ? If so, you have to develop your own system for this.
Slashdot Mirror
Correction: VARCHAR(1024) will use only the space needed for actual data, you were writing about CHAR datatype ... OTOH, maximum size of index entry is 255 bytes, so you cannot index VARCHAR(1204) either, but I doubt it is necessary. I guess you had full text search in mind ? If so, you have to develop your own system for this.