Hi Vinod, you can save \n in mysql db for every enter pressed, similarly you can keep other signs which which give you back the same indentation in java after retrieval.
Joined: Aug 08, 2012
Thanks for your replay harshvardhan ojha,
but i am not entering value in database, user enter value in form(which is part of GUI). which i want to save into database as it is. from your answer i got one clue, that if i take value from user and add necessary '\n' and ' ' according to user enter values & Then i enter them into database. May be this will work, i have to check.
But still if you have any other easy solution then please reply....
And one more time, thankss
When you say you "display" those things, you mean you display them in HTML, right?
And perhaps you didn't remember that HTML normally converts blocks of white-space to a single space character? So for example a series of three space characters would be displayed as just one space, and a new-line character (what you called "enter key") is also displayed as just one space.
In other words your problem has nothing to do with the database and everything to do with how HTML works.
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com
subject: How i store enter key and space in MySql database