Storing/Retrieving formatted text

[Anon]

I was wondering the best way to store and retrieve formatted text from a mysql database. I seem to remember someone using blob field type. The only formatting I will be doing is tabs and spaces.

Thanks

[toma42]

blob is for binary objects. Use a text field for text.

[Anon]

If I use a text field how do I keep my formatting.

[cordex]

The only problem I've noticed with formatting loss in a text field are spaces or returns before and after the text. This can be corrected with an   as a placeholder at the beginning and ending.