no HTML in database tables :(

[NovoOrganics]

Hey just quickly,

Im entering data into a table from a form on my site.

So TEXTBOX1 will be entered into EXAMPLE in UDT_EXAMPLE

Why is it that when i use a space or something that isn't carried over into the database table?

So when i type:

"Hello How are you?

Im pretty good"

And its entered into the database table and I then recall it later it prints as:

"Hello How are you? Im pretty good"

Why doesn't the database keep the spaces or the formatting?

Ian

[NST Inc Designer]

Are you actually writing the html (Hello How are you?<br />I'm pretty good)? Or are you just copy and pasting?

[NovoOrganics]

No im not using html in the text box. Thats the thing. I want the database table to recognise the space as <p></p>.

I might have an answer anyways. But if anyone knows somthing about this then please post it here.