Re: MariaDB

[Gianluigi <gradobag@xxxxxxxxxxx>]

Il 26/01/26 16:55, Gianluigi ha scritto:
> Il 25/01/26 11:05, Fabien Bodard ha scritto:
> > I'm currently trying to allow emoticons in my bdd ... but it fail with :
> >
> > Query failed: Incorrect string value: '\xF0\x9F\x99\x83\xE2\x80...'
> > for column `GambasForum`.`forum_messages`.`contenu` at row 1
> >
> > despite the fact I've changed the column charset to : utf8mb4_general_ci
> >
> > any ideas ?
>
> Hi Fabien,
>
> The attached database works with both SQLite and PostgreSQL.
> It doesn't work with MySQL, so I assume it not works with MariaDB.

The beloved AI 😇 responds like this:
How to solve in MySQL/MariaDB:
Database/Table: Set the charset to utf8mb4 and the collation to 
utf8mb4_unicode_ci. (You've already done this.)

**Connection: Make sure the application sends data using utf8mb4 (e.g., 
by running SET NAMES utf8mb4; after connecting).
Have you tried this?

Regards
Gianluigi