AppGini Community Forums

i am very little experience with php and still new with AppGini,
i would appreciate any help to solve following.
I have a table where i want to store Credentials and Password. I like to encrypt these Password when the User adds a Record and store them encrypted in the table. I nedd to decrypt them for use in bash script connected to this sql Database.
i'd like to encrypt and decrypt with AES_ENCRYPT and AES_DECRYPT
tanks a lot for any help.

My Aproach is following command:
sql("update `Credentials` set `PASSWORD`= AES_ENCRYPT('{$data['PASSWORD']}','key:MySecretKey') where `ID`='{$data['selectedID']}'", $eo);
but i get only a single character in the PASSWORD table for this record.
Please Help

solved myself,
changed table to varbinary