|
||||||
|
Views:
11,030,474 |
 
Main
| FAQ
| IRC chat
| Memberlist
| Active users
| Latest posts
| Stats
| Ranks
| Online users
| Search
|
11-21-24 11:45 AM |
||||
| Guest: Register | Login | ||||||
| Main - Posts by |
| Arisotura |
| ||
|
Developer
pancakes Level: 84    
Posts: 763/1870 EXP: 5546092 Next: 115860 Since: 01-05-12 From: France Last post: 37 days Last view: 37 days |
| Arisotura |
| ||
|
Developer
pancakes Level: 84
Posts: 764/1870 EXP: 5546092 Next: 115860 Since: 01-05-12 From: France Last post: 37 days Last view: 37 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? |
| Arisotura |
| ||
|
Developer
pancakes Level: 84
Posts: 765/1870 EXP: 5546092 Next: 115860 Since: 01-05-12 From: France Last post: 37 days Last view: 37 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? |
| Arisotura |
| ||
|
Developer
pancakes Level: 84
Posts: 768/1870 EXP: 5546092 Next: 115860 Since: 01-05-12 From: France Last post: 37 days Last view: 37 days |
Posted by Squiddy 7. Definitely not. I know that guy enough to tell you that he's not a good admin. 18. Why dedicate a NSMB2/U editor to her? The board was dedicated to her because she's been an active and good member of Acmlm's Board for so long. There isn't really a link between her and such an editor, though. Posted by Dani It's a cruel trap! They're silently devising a huge plan to take over the world. Posted by Tierage I can more than you. Posted by Squiddy 640 is a lame number! Posted by Dani Whichever has the coolest name! ____________________ Kuribo64 - melonDS want some revolution in your coffee? |
| Arisotura |
| ||
|
Developer
pancakes Level: 84
Posts: 769/1870 EXP: 5546092 Next: 115860 Since: 01-05-12 From: France Last post: 37 days Last view: 37 days |
| Arisotura |
| ||
|
Developer
pancakes Level: 84
Posts: 770/1870 EXP: 5546092 Next: 115860 Since: 01-05-12 From: France Last post: 37 days Last view: 37 days |
Posted by Squiddy What? KuriBot is Jarvis! ____________________ Kuribo64 - melonDS want some revolution in your coffee? |
| Arisotura |
| ||
|
Developer
pancakes Level: 84
Posts: 771/1870 EXP: 5546092 Next: 115860 Since: 01-05-12 From: France Last post: 37 days Last view: 37 days |
| Arisotura |
| ||
|
Developer
pancakes Level: 84
Posts: 773/1870 EXP: 5546092 Next: 115860 Since: 01-05-12 From: France Last post: 37 days Last view: 37 days |
| Arisotura |
| ||
|
Developer
pancakes Level: 84
Posts: 774/1870 EXP: 5546092 Next: 115860 Since: 01-05-12 From: France Last post: 37 days Last view: 37 days |
| Arisotura |
| ||
|
Developer
pancakes Level: 84
Posts: 775/1870 EXP: 5546092 Next: 115860 Since: 01-05-12 From: France Last post: 37 days Last view: 37 days |
| Arisotura |
| ||
|
Developer
pancakes Level: 84
Posts: 778/1870 EXP: 5546092 Next: 115860 Since: 01-05-12 From: France Last post: 37 days Last view: 37 days |
Posted by Squiddy Rather much code a converter for weird proprietary formats, so they can be edited in existing image editors. After all, why reinvent the wheel?  ____________________ Kuribo64 - melonDS want some revolution in your coffee? |
| Arisotura |
| ||
|
Developer
pancakes Level: 84
Posts: 779/1870 EXP: 5546092 Next: 115860 Since: 01-05-12 From: France Last post: 37 days Last view: 37 days |
| Arisotura |
| ||
|
Developer
pancakes Level: 84
Posts: 780/1870 EXP: 5546092 Next: 115860 Since: 01-05-12 From: France Last post: 37 days Last view: 37 days |
| Main - Posts by |
 Acmlmboard v2.5.6 (06/11/2024) © 2005-2024 Acmlm, Emuz, et al. |
|
MySQL - queries: 148, rows: 498/529, time: 8.700 seconds. |
