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