Notings of Attention™
Acmlmboard 2 Released
Github/GIT | @acmlmboard
Chatting Places
Discord

Affiliates
Super Mario Bros. X | Kuribo64
Views: 8,952,291
Main | FAQ | IRC chat | Memberlist | Active users | Latest posts | Stats | Ranks | Online users | Search
03-28-24 03:39 PM
Guest: Register | Login

0 users currently in AcmlmBoard II Software/Bug Report Forum | 1 bot

Main - AcmlmBoard II Software/Bug Report Forum - Emoji shit
Next newer thread | Next older thread


Arisotura
Posted on 06-04-15 02:14 PM, in Link | ID: 85284
Developer
pancakes
Level: 83


Posts: 764/1868
EXP: 5395393
Next: 36828

Since: 01-05-12
From: France

Last post: 654 days
Last view: 193 days
Trying to post emoji on these boards results in the string getting cut off before the emoji character. This is an issue with database encoding.


AB2.5 sets DB encoding to latin1, which isn't right considering we're storing UTF8.


But even when setting the encoding to UTF8, the aforementioned bug still happens. Because UTF8 support in MySQL is a pile of hacks and doesn't support characters with more than 3 bytes.


When setting encoding to utf8mb4, emoji characters are handled fine. Maybe seems like a lot of work for something minor (letting people post emoji crap), but on the other hand, there's the possibility that someone writes a big post with emoji crap at the beginning, and there it goes.


'a lot of work' because changing encoding on an existing database isn't magic. You'd need to change it on every varchar/text field because MySQL is dumb like that. And also modify the board to specify the right encoding when connecting to MySQL.

____________________
Kuribo64 - melonDS

want some revolution in your coffee?

Emuz
Posted on 06-04-15 03:27 PM, in Link | ID: 85286
Site Administrator

11 Hit Combo:
Mother's Rosario
Level: 108


Posts: 2653/3392
EXP: 13210702
Next: 309797

Since: 12-30-11
From: Akron, Ohio; USA

Last post: 115 days
Last view: 15 hours
Yeah, I was looking into this a bit on my own. I think it's a good idea. It's either that or put in a bunch of stupid code to block it.

It's harder to do something with such a wide scope (safely) on a life board. It may take a while but we at least have areas to focus(posts, Pms, etc). This is something we won't be doing to live until it's been tested to death on a test server. :D

The Dynamic Profile Administratorâ„¢


"Never Knows Best"
Note: if you can see this my layout broke. ALL THE CREDITS WILL BE REVEALED!!
'Victory Noriko' by @thatsheepagain.
'Chibi Dance Noriko' by @Haru__Kitsu.
'Deity's Night Out (Featuring Gabbie)'
by @thatsheepagain
Noriko Emotes by @Haru__Kitsu.
Side Bar Noriko by @thatsheepagain
'Noriko's Nature Walk' by @projectTiGER_
Emotive Noriko by @thatsheepagain.
"Space Candy Noriko" by BerryVerrine.
"Super Sharp Noriko" by Xionfes.
A gift illustration from the wonderful EverKinzPony!
"Magical Girl Noriko" by @cute_hospital!
"Patient Chibi Noriko" by @Ruii_ki!
'Dapper '60s Noriko' by @thatsheepagain.
'Shiny Chibi Noriko' by @inioli.
'Flower Veil Noriko' by @Sushiee_.
'Noriko in Realism' by @_Sarybuu.
'Noriko's Midnight Adventure' by @projectTiGER_
'Yukata Noriko' by @yunyunmaru_
'Birthday Wishes Noriko' by @thatsheepagain

Arisotura
Posted on 06-04-15 03:32 PM, in (rev. 3 of 06-04-15 05:36 PM by Arisotura) Link | ID: 85287
Developer
pancakes
Level: 83


Posts: 765/1868
EXP: 5395393
Next: 36828

Since: 01-05-12
From: France

Last post: 654 days
Last view: 193 days
I just converted K64's database to utf8mb4, everything went allright so far. Could hand you the .sql file I used as a base.


Thing is, K64's database was already UTF8 before that, so it went smoothly. Going from latin1 to UTF8 is more involved, you need some trickery to keep MySQL from trying to convert the already-UTF8 data into UTF8. A solution may be creating a new empty database with proper UTF8 fields, exporting the old one and reimporting. I've been dealing with that shit before too, but I don't remember the details.

____________________
Kuribo64 - melonDS

want some revolution in your coffee?

Next newer thread | Next older thread
Main - AcmlmBoard II Software/Bug Report Forum - Emoji shit


Acmlmboard v2.5.5 (10/04/2020)
© 2005-2024 Acmlm, Emuz, et al.

Page rendered in 0.043 seconds. (775KB of memory used)
MySQL - queries: 74, rows: 501/535, time: 0.035 seconds.