LOAD DATA error #1366 Incorrect string value: - Source

Revision: 129476
User: Paxton Scott
Date: 2023-08-27 21:21

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.

LOAD DATA error #1366 Incorrect string value: - Source

Products

Services

Pricing

Resources

About Us

Download MariaDB