mysql 加密后乱码

-- 创建数据库时指定字符集
CREATE DATABASE mydb CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- 创建表时指定字符集
CREATE TABLE mytable (
    id INT PRIMARY KEY,
    name VARCHAR(255)
) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- 连接数据库时设置字符集
SET NAMES utf8mb4;

-- 示例：加密
SET @plaintext = 'Hello, World!';
SET @ciphertext = AES_ENCRYPT(CONVERT(@plaintext USING utf8mb4), 'encryption_key');

-- 示例：解密
SET @decrypted_text = CONVERT(AES_DECRYPT(@ciphertext, 'encryption_key') USING utf8mb4);

-- 创建数据库和表
CREATE DATABASE mydb CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
USE mydb;

CREATE TABLE mytable (
    id INT PRIMARY KEY,
    name VARCHAR(255)
) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- 插入加密数据
SET @plaintext = 'Hello, World!';
SET @ciphertext = AES_ENCRYPT(CONVERT(@plaintext USING utf8mb4), 'encryption_key');
INSERT INTO mytable (id, name) VALUES (1, @ciphertext);

-- 查询并解密数据
SELECT id, CONVERT(AES_DECRYPT(name, 'encryption_key') USING utf8mb4) AS decrypted_name FROM mytable;