String storage problem
I've written an app that needs to have user-submitted strings, with (seperate) formatting information like font and colour. It returns random strings from a given set for that person. I'm moving from flat file to SQL database, and am wondering how the best way to do it is. My current solution involves two tables - one to store the strings and formatting information, and another to store all the different "selection". However, the only way I see of doing that is if one column is the ID of the "selection" and another is a comma-seperated list of all the IDs from the other table of that selection.
My second idea is having two columns - the minimum and maximum IDs of the selection, seeing as they're all next to each other.
Is there a better way. Should I be going for two tables? Should I even be moving to an SQL DB in the first place? Remember, the strings are specific to that person only, so if they all could be stored together it would be ideal.