Gossamer Forum
Home : Products : Gossamer Links : Discussions :

is there a way to compress or pack text to make it very short

Quote Reply
is there a way to compress or pack text to make it very short
HI there,

I'm wondering if there's an appropriate method to convert multiple fields into something short and sweet that can be, saved, and queried upon to check for duplicates.

Basically I need to check if an entry is a duplicate. ie, name, address1, address2, city state zip.
In the past twenty days I already have a over 2000 submissions. I expect that as the database gets larger that checking if the address is a duplicate will take longer and longer as times goes by so I'm wondering if there's a proper way to take that information and convert it/pack it/compress it into something short so that I can save it in one field and later query that field for the compressed value instead of all 6 values in six different fields.

thanks very much for any insight to this.

peace.