As the title states, i´m not sure whether I should/can use a blob field to store text. I need to increase the amount of text in a field to over 255. Is the blob the way to go?
As a rule of thumb, BLOB is not the way to go when arbitrary text is desired -- Assuming the contents of a BLOB column is ASCII can become a security issue! Instead, you should be looking at CLOB (UTF-8) or NCLOB (UTF-16) data types (if supported). The fallback (for formats that don't support LOB types) is concatenation of string fields, or ancillary files with data, and the name of the file in the string field.