Naming website strings

Question

There are 2 types of strings in any website:

1. Shorter with no formatting (menu items, section titles, labels...).
2. Longer with formatting (content).

If you have to store these 2 types of strings in 2 different database tables, how would you call these 2 tables?

Answer 1

In SQL the shorter ones are generally called varchar and the longer ones text.

That's not to say that you'd never put HTML in a varchar, just that text fields are better suited for arbitrary-length strings.

Answer 2

1. Localization strings?
2. Content

In short, call the tables after their content.

If you have both application texts, content titles and content you might use three tables, "ApplicationTexts", "ContentTitles", "Content".

Answer 3

1. Labels
2. Content