Login
Register
Login
Register
Communities
Directory
Help
Language
Legal
Search
Communities
Directory
Help
Language
Legal
Search
Visit
Poke
Waitman Gobble
Tue, 21 May 2024 03:10:32 -0400
from Get Ready To Rumbly
@
Mike Macgirvin (dev)
i think you explained this in the past but a user asked me about it. Just checking in case there is some issue with my server setup."emoticons on android phone cause an error"
Link to source
Screenshot_20240521_034632_Edge(1).jpg
1 Like
SpaceLifeForm (4 months ago)
Visit
Poke
Mike Macgirvin 🖥️
Tue, 21 May 2024 03:48:21 -0400
from Y
emoticons (smileys) or emojis? Shouldn't be any errors, but lord knows what the phone is actually doing. It might be trying to cut/paste an image blob and that probably won't work. An emoji picker should work. Emoticons like
: - ) and ; - )
should work.
Link to source
Visit
Direct Message
Poke
SpaceLifeForm
Tue, 21 May 2024 05:20:16 -0400
from mastodon
@
Waitman Gobble
@
Mike Macgirvin (dev)
UTF-8 problem? Filters?
Link to source
Visit
Poke
Waitman Gobble
Tue, 21 May 2024 06:34:32 -0400
from Get Ready To Rumbly
it seems utf-8 related, pasting a UTF-8 smiley causes the same error, but i'm not seeing anything in the logs. i will look for the code that reports that error and see what's happening. The "Preview" works but error happens on submit.
it's failing on db insert:
ERROR 1366 (22007): Incorrect string value: '\xF0\x9F\xA4\xAA' for column
rumbly
.`item`.`body` at row 1
Link to source
Visit
Poke
Waitman Gobble
Tue, 21 May 2024 06:44:17 -0400
from Get Ready To Rumbly
The problem is all the tables are utf8mb3_general_ci and the "smilieys" are 4 byte utf-8 characters.. I'm sure i didn't "change" the tables to utf8mb3 did the install schema "used" be utf8mb3? it's odd. I think changing all the tables to utf8mb4_ would solve it. (the current install schema sets to DEFAULT CHARSET=utf8mb4 it seems)
Link to source
1 Like
elmussol (4 months ago)
Visit
Poke
Mike Macgirvin 🖥️
Tue, 21 May 2024 07:24:43 -0400
from Y
The default has been utf8mb4 for a number of years now. Before that it was just utf8. Don't recall ever using mb3 except the "old" utf8 might be called mb3 now because I do recall it was 3 bytes and we needed to migrate to utf8mb4 to support some of the "newer" emojis - but iirc this was 5-8 years ago.
Link to source
Visit
Poke
Waitman Gobble
Tue, 21 May 2024 07:55:31 -0400
from Get Ready To Rumbly
It's strange the tables on my server are mb3. I will "fix" it. Site may be down for an hour or so
Link to source
Visit
Poke
Giac El Vecio
Tue, 21 May 2024 09:40:37 -0400
from Diversi Spiritus
Yes, my concern was the following: if you send the same message to 50 different sites and just one does not accept the message because of the smiley, then it is better to notify the site administrator, because obviously there is something wrong with that side.
Link to source
1 Like
Waitman Gobble (4 months ago)
Login
Login/Email
Password
Remember me
Login
Register
Password Reset
Remote Authentication