Survey with many columns

My colleague is working on a project which should store data from a long survey. His single table now has many, many columns (labelled "a_1_1" and so on), with different data types (some boolean, some integers, some text, and so on).

Is there a way to optimize this?
E.g. what would be if the next survey comes along, one which has different fields. Would everything need to be redone from scratch? Received on Fri Aug 15 2003 - 11:16:14 CDT