I am developing a web app in Laravel where I have to ask users a set of Yes/No questions and save the answers in the database. I thought that I should try and save all answers in binary rather than saving them one-by-one since the number of questions vary from time to time. Say in three questions, the user answered Y-Y-N; that would convert into "110".
Now, on the database side, should I:
- save the data as is (varchar)
- use binary/blob
- convert to int and save sa int
Not sure which option is the best, considering that the system sometimes output 50 questions.
MySQL -V info:
mysql Ver 14.14 Distrib 5.5.62, for debian-linux-gnu (x86_64) using readline 6.3