||SQL Server Tips by Gama and Naughter
TEA Block Cipher
David Wheeler and Roger Needham at Cambridge
University developed the Tiny Encryption Algorithm in 1994. It is
64-bit block cipher with a key size of 128 bits. As with the
blowfish implementation, the XP_CRYPTOAPI implementation
automatically handles the padding upon encryption and removal after
decryption. The code to implement the algorithm is taken directly
from the Cambridge University web site describing the algorithm.
Please note that the implementation provided operates in ECB mode as
opposed to CBC mode.
The above book excerpt is from:
Turbocharge Database Performance with C++ External Procedures
Joseph Gama, P. J. Naughter