I have a database table that currently looks like this:
PageField -Id (Int, PK) -FieldType (String) Can be Text, Decimal, Integer or Bit -Value (This stores the value regardless of the FieldType, so it is not strongly typed)
Should I remove the Value column and replace it with 4 separate columns TextValue, DecimalValue, IntegerValue, and BitValue?
The data type would be set to what is relevant. This would mean in every row 3 of these 4 columns would be