Re: Data migrations
I once had to deal with a customer whose staff used to type credit card details (including CVV's, Expiry dates, etc) into memo/note fields.with the essential reason being that the staff didn't feel like taking the details again when the customer inevitably called back to place another order.
This was in a plain text field on a non-encrypted database