Strings

[Wej]

What is the best to hold strings? Varchar, text, or blob types?

I am guessing varchar is used for strings where you know the max length. But what about blobs and texts?

[TheBearMay]

Blobs (binary large objects) tend to be more useful for images, etc. Varchar vs. text efficiency varies by the database. Some no longer use the text and instead convert it to varchar if it is specified.