Insert in Database Column (Varchar) Formatted Data Through Insert Statement.

We have A Text box field where User can Enter Data. This data can be formatted. When I say formatted, I mean it shall contain Special Characters, Enter(Ascii 13), TAB and Paragraphed.

We are getting this information in Java String and Inserting it in database(Varchar column). During this process we loose formatting Here is example. Suppose someone Entered Text like this:

Deja is a great website to find all source of information & Text. Usually Deja has different sorts of users groups where people come and find solutions to their problems
However Deja was recently bought by yahooo.

          Here is summazrised reasons why I would go to Deja.
          1. Reason 1.
          2. Reason 1.   
          3. Reason 1.

Text Ends

When we insert Above data in Database and See the Result all formatting is lost and looks like this

Deja is a great website to find all source of information & Text. Usually Deja has different sorts of users groups where people come and find solutions to their problems However Deja was recently bought by yahooo. Here is summazrised reasons why I would go to Deja.1. Reason 1. 2. Reason 1 3. Reason 1.

Text Ends

Please let me know how to resolve this. Do I need to Read data in AsciiStream , But how do I insert data using SQL in Database.

I have to do some Java and Oracle Solutions. I shall appreciate any help in this regard.
Regards
Sanjay Received on Fri Apr 18 2003 - 02:23:41 CEST