I need insert any my bank-card information to sqlite db, so when I insert the 
car number like '3312' and car password like '7711', but I wanna nobody can see 
the password, so I create a function encode('7711','key') and decode(select 
from stable where carnum=3312, 'key') to see the password, the key is like 
'plkey777' to encode or decode the password , but I don't know how to realize 
that. and I have a function to encode and decode :  procode(aa,bb,flag);
char *aa="plkey777";
char *bb="7711";
procode(aa,bb,1);       //here is to encoding the char ,bb result is bb

insert into stable select "3312",bb;


procode(aa,bb,2);    //here is to decoding the char ,bb result is bb
select carbumber,procode(aa,bb,2) from stable 

I don't know how to do this. the code upside isPseudo code。
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to