Carriage Returns in Blobs

[Aludaan]

Hello,

I have a script that uses a textarea to have a user enter notes in. It then stores the textarea info to a blob in MySQL. When I load the blob and display it in a textarea it displays fine but when I try to display it as regular text on a web page it does not enter any of the carriage returns.

So for example this is what I would enter in the textarea:
This is a test
This is just a test

Then I click the submit button and off it goes to MySQL. Now if I load the blob from MySQL and display it in a textare it displays:
This is a test
This is just a test

But if I load the blob in the same exact way and try to just echo it straight to the webpage it displays like this:
This is a test This is just a test

Any idea how I can get the carriage returns to work?

Thanks for any help you can provide,

Aludaan

[devinemke]

run the data thru [man]nl2br[/man] before displaying in the browser.
why are you using BLOB's to store text?

[leetcrew]

it is better to use longtext or text instead of blob

[Aludaan]

Thanks a ton man. That worked perfectly.

And the reason I am using blobs are because it is being used to store notes that could run rather large. (An unknown size to be specific.)

Thanks a lot,

Aludaan

[devinemke]

Aludaan wrote:

...And the reason I am using blobs are because it is being used to store notes that could run rather large. (An unknown size to be specific.)

BLOB's are typically used to store binary data. if you are only storing text then use a TEXT column type.