Hi all
I came across a requirement where i have to store paragraphs of data (not huge maximum of 5 paragraphs) in database, i have kept the column as TEXT. while insertion every thing is going fine it is storing as paragraphs(saw that in database). but while retrieving it is trimming all the spaces between the paragraph's and giving it as a single string. i read somewhere that we have to get the text as CLOB i tried that but it is also not working. below is the code.
Clob descClob = rs.getClob(2);
String descString = descClob.getSubString(1, (int)descClob.length());
engArticle.setNewsDescription(descString);
Thanks a lot in advance.
Regards
Kranthi.