How to store data type text in key/value pair settings table

Asked Apr 21 '17 at 11:04

Active Apr 22 '17 at 05:04

Viewed 577 times

I was reading this discussion: Using a Single Row configuration table in SQL Server database. Bad idea?

But I didn't find the answer I was looking for regarding the text data type.

If I have a key/value pair settings table in the database, how would I store a text data type?

I don't want to add a field with the data type text because I guess this would be a performance issue.

I'm thinking that maybe I could have another table where I store the text and then link it together with an ID. That way there would be no bad effect on the main settings table.

Like so:

tblSettings
[id], [key], [valueChar], [valueInt], [valueDate], [valueFloat], [valueMeta]
1, 'template', null, null, null, null, 1

tblMeta
[id], [valueText]
1, '<html>....'

Would that be a good solution or is there a better one that I'm not thinking of?

edited May 23 '17 at 12:09

Community

asked Apr 21 '17 at 11:04

M.D

Edit your question and tag with the database you are using. `text` is not a standard SQL type. – Gordon Linoff Apr 21 '17 at 11:05
See the tag I added. – Rick James Apr 22 '17 at 05:04

How to store data type text in key/value pair settings table

0 Answers0