I am using this package(elgiborsolution / laravel-database-encryption) to encrypt data in my database. When trying to use "unique_encrypted:accounts", I get this error:
SQLSTATE[42000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near '('.
select
top 1 *
from
[ accounts ]
where
CONVERT(
AES_DECRYPT(FROM_bASE64(`accountName`), '75aa614adfffb3c6') USING utf8mb4
) = 'Test'
This is my code:
$validate = validator(['accountName' => $request->accountName], ['accountName' => 'required|string|unique_encrypted:accounts,accountName']);
Does anyone know what I am doing wrong?