Displaying 1 result from an estimated 1 matches for "ccnumblob".
2005 Jul 11
0
anyone using ENCODE and DECODE in SQL in ActiveRecord?
I keep some sensitive information encoded using MySQL''s ENCODE and
DECODE commands in the database table.
-- example SQL:
SELECT *, DECODE(ccnumblob, ''salthere'') AS ccnum FROM customers WHERE id=2;
UPDATE customers SET ccnumblob = ENCODE(''4321432143214321'',
''salthere'') WHERE id=2;
INSERT INTO customers (name, ccnumblob) VALUES (''Bob Dobalina'',
ENCODE(''4321432143214...