My app uses different types of persistent data (setting) that I would like to save in one DB table.
The values I want to keep in the DB are from different kind of types (e.g. int, strings, bin…)
I thought about create columns for each type that I need(IntCol, StrCol, BinCol…) but it will be a waste of space since I will only use one columns in a row. I also thought about the option of keep them all as binary type but then I will have to do the right casting for each value.
Is anybody can advice for a better why to do it?