File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes How to compress text data before storing it in database Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "How to compress text data before storing it in database" Watch "How to compress text data before storing it in database" New topic
Author

How to compress text data before storing it in database

Anand Achyut
Greenhorn

Joined: Jul 17, 2001
Posts: 6
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
Phil Berggren
Greenhorn

Joined: Jul 13, 2001
Posts: 5
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 agree. Here's the link: http://aspose.com/file-tools
 
subject: How to compress text data before storing it in database