How to compress text data before storing it in database
Anand Achyut
Greenhorn
Joined: Jul 17, 2001
Posts: 6
posted
0
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
posted
0
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)......
0
