mysql> insert into fc_Customer (User_Password) values(password("abcd"));
Query OK, 1 row affected (0.00 sec)
However, when I try to select the line by searching on the password here is
the response:
mysql> select * from fc_Customer where User_Password=password("abcd");
Empty set (0.00 sec)
I can view see that the record was added and that the password was
encrypted, but I can't compare it or select it using password function.
Make sure that the column width is long enough (16, I believe). It's possible that the inserted encrypted value is being truncated.
Larry