As I wrote I tried and failed; you see the screenshot.
So the easy answer to your problem "But I would like to know for sure." is:
If you are able to create it with TOAD or phpMyAdmin outside LS, it's a LS issue, if not, it's a MySQL restriction.
Joffm
Volunteers are not paid.
Not because they are worthless, but because they are priceless
shiva522 wrote: I think this discussion should be completed, since no one knows the answer and does not waste your time guessing.
Open a bugticket in the tracker with the limit size gap. That way you might get the direct attention of the developers of LimeSurvey. Currently none of them has joined this discussion thread here.
Limitations, as far as I understand, come from MySql itself.
In "Toad for mysql" I tried manually creating a table based on the script of the created table and adding fields of the same type and dimension (varchar (5)) to the number where I encountered the problem. Experimentally (reducing the number of fields) reached the 1575 field, when the table allows creating.
After, I tried varchar (5) instead of varchar (1). The result is the same. 1575 fields - the number at which I was able to create the table.
So Limesurvey has nothing to do with it.
