Laravel Crypt, does it make sense to encrypt data in a DB?

Question

Data protection

For example, there is a card number (product / service). I would like to encrypt it on the DB side in case the DB is hijacked. However, after all, the decryption algorithm can be seen how the Crypt provider in Lara works.
Does it make sense to encrypt? After all, the algorithm is open.

Answer 1

and with what joy do you keep your card number?
maybe you already got PCI-DSS? but then you would not have such questions.
in general, the data is encrypted to minimize the possible consequences (for example, stealing a backup copy or dumping only the database). algorithms, although open, but without a secret, they will not help to recover data in any way.
but if everything has already been leaked (both the base and the source code with the secret) - then pichal-bida.