It was amazing to have superb help from all of you !!
I have typical problem..
An Employee's address is entered in "textarea", multiline text box and want to display it (onn retrieval) the way user has entered !!
The user types a sentence / line of address and then press "ENTER" key.
The data seen on the screen (to the user who is entering text) is in separate lines delimited by <crlf> or enter key.
When I store this data into field type "varchar" , I get single string and I am unable to display the data the way user has entered...
Please guide me as how do I store this data and how the same can be displayed in the same manner as entered by user.
User Enters data as follow
When I display it the same is displayed as
111111, 2 33333, 444444 55555 66666
Please help !!