Can some one tell me are there any limitations in using the following functions:
1.Compare
2.CRC32
3.CheckSum
and what is the difference between CRC32 and CheckSum?
Can i just compare strings with the following expression
"String1"="String2" or "String1" <> "String2"
Any Inputs are greatly appreciated.
Thank you all.
Compare , CRC32, CheckSum functions and their limitations
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 614
- Joined: Fri Feb 06, 2004 3:59 pm
Kollurianu,
the best and 100% guaranteed method is to do a String1=String2 comparison. But if the string is 500 characters long it sometimes makes sense to store a short CRC32'd string instead of the original and then do a comparison on the smaller value. The upside is drastically less storage space needed, the downsides are (a) more CPU/processing time to calculate the algorithms and (b) a slight possibility of getting different strings with the same CRC32 code
the best and 100% guaranteed method is to do a String1=String2 comparison. But if the string is 500 characters long it sometimes makes sense to store a short CRC32'd string instead of the original and then do a comparison on the smaller value. The upside is drastically less storage space needed, the downsides are (a) more CPU/processing time to calculate the algorithms and (b) a slight possibility of getting different strings with the same CRC32 code
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 232
- Joined: Sat May 07, 2005 2:49 pm
- Location: USA
-
- Premium Member
- Posts: 614
- Joined: Fri Feb 06, 2004 3:59 pm