GBase 8s V8. 8 SQL Guide: Tutorial - 5.3.1

5.3.1 Use column level data encryption to protect credit card data
The following example uses column level encryption to protect credit card data .
Use column level encryption to protect credit card data ：
1. Create table ：create table customer (id char(30), creditcard lvarchar(67));
2. Insert encrypted data ：
a. Set session password ：SET ENCRYPTION PASSWORD "credit card number is encrypted";
b. Encrypt data .
 INSERT INTO customer VALUES
 ("Alice", encrypt_aes("1234567890123456"));
 INSERT INTO customer VALUES
 ("Bob", encrypt_aes("2345678901234567"));
3. Use the decryption function to query the encrypted data .
 SET ENCRYPTION PASSWORD "credit card number is encrypted";
 SELECT id FROM customer 
 WHERE DECRYPT_CHAR(creditcard) = "2345678901234567";
important ： It takes up more space than unencrypted data . Columns wide enough to store plaintext may need to
Increase the width to support column level encryption or cell level encryption . If you want to insert an encrypted value, the declaration width is less than the encrypted string
The column of , Then the column stores the truncated value , The value cannot be decrypted .
More about encryption security , see also 《GBase 8s Administrator's Guide 》.
For more information about the syntax and storage requirements of the built-in encryption and decryption functions , see also 《GBase 8s SQL guide ： grammar 》.