The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-16. For the latest, interactive version please visit https://mariadb.com/kb/.

ERROR 1366 (22007): Incorrect string value: '\xAB\xB8\xA3\xCBA/...'

Hi,

I am trying to encrypt data in mariadb table but it is giving me error. Please find the details below and help me to get it resolved.

Table Info:

+-------+--------------+------+-----+---------+-------+

FieldTypeNullKeyDefaultExtra

+-------+--------------+------+-----+---------+-------+

datavarchar(250)YESNULL

+-------+--------------+------+-----+---------+-------+

Error while inserting Data:

MariaDB [mydb]> insert INTO test (data) VALUES (aes_encrypt('mydata','key123456')) -> ; ERROR 1366 (22007): Incorrect string value: '\xAB\xB8\xA3\xCBA/...' for column `mydb`.`test`.`data` at row 1 MariaDB [mydb]>

MariaDB Version mariadb Ver 15.1 Distrib 10.5.15-MariaDB, for debian-linux-gnu (aarch64) using EditLine wrapper

OS Details

Linux raspberrypi 5.15.32-v8+ #1538 SMP PREEMPT Thu Mar 31 19:40:39 BST 2022 aarch64 GNU/Linux

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.