The 5.0 documentation that I have says that you can specify a length for a TEXT column, and that this will affect the storage space used by the column data. When I specify TEXT(n), however, n is ignored. It won't be shown in a SHOW CREATE, nor in any other way.
Is this a feature that came and went? Was the documentation wrong? (I downloaded a compiled Windows help file.) Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 <http://www.the-infoshop.com> www.the-infoshop.com <http://www.giiexpress.com> www.giiexpress.com www.etudes-marche.com