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

You are viewing an old version of this question. View the current version here.

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

Comments

Comments loading...
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.