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/.

LOAD DATA error #1366 Incorrect string value:

Greetings! Using mariadb 10.6.13 on opensuse 15.4 Installed this Spring and in the process of moving an application from a multi-value database to Mariadb and PHP. I primarily use PHPMyAdmin to manage the database. I have imported data to a few files and interact with them with PHP and a browser application.

I'm stuck importing some string data containing é and other accent characters. I get the error message: Warning: #1366 Incorrect string value: '\xE9ro/Da...' for column.... I thought this was a character set issue so. Checking character sets... \s; (server status) originally displayed: Server characterset: utf8mb4 Db characterset: utf8mb4 Client characterset: utf8mb3 Conn. characterset: utf8mb3

So, I performed SET CHARACTER SET utf8mb4; and now, \s: shows: Server characterset: utf8mb4 Db characterset: utf8mb4 Client characterset: utf8mb4 Conn. characterset: utf8mb4

I don't know what to try next. Any thoughts?

(My apologies if this issue is covered somewhere in the knowledge base and I failed to find it...(I looked :-)

Have fun Paxton

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.