I got a kind of questionnaire style thing running over internet for which the data is to be stored into a DB on the server.
My question is: how should i ideally get the data into my DB?
I can for example let the user fill in the whole thing and then send a string to my DB containing all the data like this: 1,2,1,1,2,4,1,4,1,2 and then decide if I put it in one field or split it up into many fields.(example for 10 questions, each number represents the number of the answer the user chose).
This method(including the storing in one single field) is preferred by the developer of the internet part.
Is there any better method using transactions, triggers or whatever?
I dont like the idea of having the whole stuff in one field so question 2 is:
How to split that string up and when (I know about the string processing features of SQL)? Store in a field first or process before it reaches DB?