Hello all I am writing an application which needs to store lots of text data in database. Is there a way of compressing text data before i store it in Database. I use Oracle 8 database and Weblogic server for my application. Please help!!! Thanks in Advance Anand
This isn't really compressing the text field, but it will get rid of leading and trailing spaces: In your SQL statement to insert into your table add trim(FieldName) to each text field. For example if you have a text field called FirstName, it would be trim(FirstName), trim(LastName)......
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 to compress text data before storing it in database