SELECT AES_ENCRYPT(password, 'abcdffffdsfddafdasfddasd'); is work! I think I need to find out what is the data type and data lengh for storing the encrypt password Thanks, JP
________________________________ From: Simon Slavin <slav...@bigfraud.org> To: Joanne Pham <joannekp...@yahoo.com>; General Discussion of SQLite Database <sqlite-users@sqlite.org> Sent: Wednesday, October 19, 2011 6:24 PM Subject: Re: [sqlite] sql statement to update the data in the table On 20 Oct 2011, at 1:49am, Joanne Pham wrote: > it seems like it didn't work. > For example the password is 'password'. I ran the update statement below and > do the AES_DECRYPT the password is null instead of 'password'. Try just SELECT AES_ENCRYPT(password, 'abcdffffdsfddafdasfddasd'); Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users