Re: [sqlite] Calculating a checksum within SQLite, without using an extension...

2011-01-08 Thread Thomas Olson
Hello again, I found a problem with the example I sent earlier. I'm fairly new to dealing with blob data and didn't realize that substr([some_blob], 1, 1) didn't return a byte value, at least not one that can be cast as its' decimal integer value. I have fixed the problem by using a lookup

[sqlite] Calculating a checksum within SQLite, without using an extension...

2011-01-08 Thread Thomas Olson
Hello, I was bored so I wrote a quick recursion test that calculates a Fletcher32 checksum and it works! At least I think it does, I can't find any test vectors for Fletcher32. I realize it would be better to implement this as an extension library, but I was using it as an exercise to get a