On Mon, March 12, 2007 8:04, Neil Tompkins said:
> I've been researching the best method to store credit card numbers in a
> database which are saved encrypted. My version of mysql is 3.23 therefore
> think the only function I could use is
> ENCODE() and DECODE().
> I've tried these functions and they appear to work as I want. I've a
> of questions though, can I use varchar when saving the data and are these
> functions suitable for my requirements ?
use 'Bin' versions of fields since the encoded data may be binary.