elgiborsolution / laravel-database-encryption with unique_encrypted:accounts

Viewed 12

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?

0 Answers
Related