link at page: https://assistenza.decoresin.com/
I had to modify connection.php as shown here:
I’m not sure if Wappler handles this automatically now.
what is the exact value stored in your database? Can you share a screenshot please?
Do you have a direct access to your database like using phpmyadmin to check directly the db values?
So they don’t seem to be stored properly? Are you sure you have set the database encoding / table collation to utf8mb4
?
same result ???
You use PHP?
Edit dmxConnectLib/lib/db/Connection.php
line 61:
PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8',
change it to:
PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8mb4',
ok it work fine ! Thank you
one question
how can I view è color emoticon in my web page ?
at this moment I see this:
the emoticon is black and white, I want view the real color emoticon !
Hey @patrick,
Any idea how to make it work on a NodeJS project too?
Also, since I’m on a Docker hosting, is there any easy way to convert the table to utf8mb4?
bump - I’d like to know this too for Node JS
You can add the utf8mb4
charset to your connection settings. Also make sure the database/table encoding to utf8mb4
Sweet! Thanks Teo
Hi Teodor, is it possible to get to this screen for an existing database? I’m able to see this if I select “New Database Connection” but I’m unable to find an edit option for the current connection Thanks!
Hey there,
I’ve just been trying to figure this out, and I couldn’t see the database connection properties either because my connection kept showing below.
So I had to modify my docker-compose.yml in the Targets folder. I added the highlighted below and restarted the server. It all started to work.
Make sure your tables and columns are set to utf8mb4 and utf8mb4_unicode_ci respectively.
You can get to this screen in the workflows tab using docker its under globals