Welcome to TangoWorldWide!
You are a Guest, which means you cannot use
all possible features on this forum.
Sign in or Register, to enjoy full functionality. It'll only take 2 seconds!
434 Players in 2 Servers

Author Topic: 🔮 Website Data Handling Changes (utf8mb4)  (Read 818 times)

0 Members and 1 Guest are viewing this topic.

Offline balon

  • Operations Director
  • 5k Poster
  • *
  • *
  • *
  • Topic Author
  • Posts: 7524
  • Making moves
    • http://steamcommunity.com/id/tjbalon
    • https://twitch.tv/tjbalon
    • https://twitter.com/TangoWorldWide
    • View Profile
  • Liked: 2147
  • Likes Given: 395
  • User Avatar

    tw tj

    Offline


  • Total Badges: 52
    Badges: (View All)
    Slaughter Gang Spammer-50 Goated OG Christmas 2019 Thanksgiving 2019 Halloween 2019 rich boi 5 Year Coin Coby Wizowd Summer 2018 Croc-a-dil 4 Year Coin 12 Days of Christmas 2017 Christmas 2017 Halloween 2017 Roasting Event 2017 Summer 2017 Gstad's Squad Blackhat Fly Shit Only 3 Year Coin Christmas 2016 5000 Posts Thanksgiving 2016 Mobz Award Halloween 2016 The Rich Bitch Summer 2016 Drunk Award 12 Days of Christmas Badge Collector (20) 2 Year Coin aPn's Award Christmas 2015 Spammer-25 Badge Collector (15) Thanksgiving 2015 Halloween 2015 Quick Collector (10) Badge Collector (10) Invisible Quick Poster Mobile User Quick Collector (5) 100 Poll Votes Badge Collector (5) 2500 Posts 1000 Posts 500 Posts
🔮 Website Data Handling Changes (utf8mb4)
« on: May 05, 2021, 05:00:54 pm »
Due to the increasing amount of users playing FiveM with special names, steam usernames taking advantage of new encodings, and general progress that should be made I've gone through today and made several changes to the website to better support the new utf8mb4 encodings for better emoji/character support.

Previously, characters such as 🔮 or 🐌 would error out and become � due to how we strip content before it is pushed to the database.

As of today, this is no longer the case. Instead with the recent migration of CA-SQL from MariaDB 10.1.x -> 10.5.x, there was a lot more support added for 712b+ storage (namely utf8mb4 support). Thus, the database is now capable of handling these newer characters so we've made some changes to where they are supported on the forums:
  • Steam usernames will now properly display
  • Steam statuses will now properly display
  • Forum posts should be able to include these special characters

I am unaware if this is going to cause issues long-term, I have gone through and updated what I could up to this point. If there are issues, I may revert this update and go back to stripping the characters.
-

Offline loo ★

  • Community Director
  • Forum Addict
  • *
  • *
  • *
  • *
  • *
  • *
  • Posts: 1233
  • ♪ Currently listening to music... ♪
    • http://steamcommunity.com/id/loo112
    • https://twitch.tv/loo112
    • View Profile
  • Liked: 185
  • Likes Given: 249
  • User Avatar

    loo ★

    Online


  • Total Badges: 35
    Badges: (View All)
    Brain Dead Slaughter Gang 5 Year Coin 1000 Posts Homoflexual Any amongers? 100 Poll Votes Christmas 2019 4 Year Coin Invisible Lovable 3 Year Coin Certified Cutie 500 Posts Badge Collector (20) Summer 2018 Member of the Month 2018 Coby Wizowd Spammer-50 Badge Collector (15) Spammer-25 Gstad's Squad 2 Year Coin Badge Collector (10) Christmas 2017 Halloween 2017 100 Posts Quick Poster Mobile User Badge Collector (5) Summer 2017 1 Year Coin Christmas 2016 Halloween 2016 Summer 2016
Re: 🔮 Website Data Handling Changes (utf8mb4)
« Reply #1 on: May 05, 2021, 05:30:22 pm »
This is 🔥
Need to talk to me 1 on 1? Please select a time to talk!

Discord: Loo#0001
Steam: tw loo ★




★ Check out what Blackstars is all about ★

jess was here 💜

Spoiler: Tango Positions (click to show/hide)

Offline balon

  • Operations Director
  • 5k Poster
  • *
  • *
  • *
  • Topic Author
  • Posts: 7524
  • Making moves
    • http://steamcommunity.com/id/tjbalon
    • https://twitch.tv/tjbalon
    • https://twitter.com/TangoWorldWide
    • View Profile
  • Liked: 2147
  • Likes Given: 395
  • User Avatar

    tw tj

    Offline


  • Total Badges: 52
    Badges: (View All)
    Slaughter Gang Spammer-50 Goated OG Christmas 2019 Thanksgiving 2019 Halloween 2019 rich boi 5 Year Coin Coby Wizowd Summer 2018 Croc-a-dil 4 Year Coin 12 Days of Christmas 2017 Christmas 2017 Halloween 2017 Roasting Event 2017 Summer 2017 Gstad's Squad Blackhat Fly Shit Only 3 Year Coin Christmas 2016 5000 Posts Thanksgiving 2016 Mobz Award Halloween 2016 The Rich Bitch Summer 2016 Drunk Award 12 Days of Christmas Badge Collector (20) 2 Year Coin aPn's Award Christmas 2015 Spammer-25 Badge Collector (15) Thanksgiving 2015 Halloween 2015 Quick Collector (10) Badge Collector (10) Invisible Quick Poster Mobile User Quick Collector (5) 100 Poll Votes Badge Collector (5) 2500 Posts 1000 Posts 500 Posts
Re: 🔮 Website Data Handling Changes (utf8mb4)
« Reply #2 on: May 05, 2021, 08:14:27 pm »
 8)
-

Offline Alamo

  • BOBBY SHMURDA IS FREE
  • Veteran Member
  • Forum Addict
  • *
  • *
  • *
  • *
  • *
  • Posts: 2000
  • ALAMO
    • View Profile
  • Liked: 665
  • Likes Given: 347
  • User Avatar

    garden gnome

    Offline


  • Total Badges: 23
    Badges: (View All)
    3 Year Coin Blackstars Secret Santa 2020 Badge Collector (20) 2 Year Coin Goated Any amongers? Adorable Badge Collector (15) Stargazers Invisible Christmas 2019 1000 Posts Badge Collector (10) 100 Poll Votes Certified Cutie Comedy Gold 1 Year Coin Badge Collector (5) Thanksgiving 2019 500 Posts 100 Posts Quick Poster Mobile User
Re: 🔮 Website Data Handling Changes (utf8mb4)
« Reply #3 on: May 05, 2021, 09:00:59 pm »
🤷‍♀️😕🤔😫🥶🕋🔇


clown, watch your lip

Lol nothing to make fun of seeing as I am more successful then you will ever be you brainless, spineless ape, Get back in your cage and you might get a banana because you belong in the fucking zoo.

do you want my autograph u fan ? putting me in ur signature it wont get u a skeet invite nn

Time of occurrence (Date and Time, Map and Round): 4:39 PM PST (IA timezone)

Offline Vision.

  • BANNED
  • Forum Junkie
  • *
  • Posts: 646
    • https://steamcommunity.com/profiles/76561198160421579/
    • https://www.youtube.com/channel/UC0B8TrfXtJnLX4hoyU8adYg?view_as=public
    • View Profile
  • Liked: 77
  • Likes Given: 339
  • User Avatar

    vi⁧⁧⁧⁧sion

    Offline


  • Total Badges: 21
    Badges: (View All)
    Badge Collector (20) Slaughter Gang Invisible 100 Poll Votes 4 Year Coin Badge Collector (15) 500 Posts 3 Year Coin 2 Year Coin Summer 2018 Badge Collector (10) Quick Poster 100 Posts Gstad's Squad Mobile User Badge Collector (5) Christmas 2017 Halloween 2017 Summer 2017 1 Year Coin Christmas 2016
Re: 🔮 Website Data Handling Changes (utf8mb4)
« Reply #4 on: May 06, 2021, 01:03:54 am »
🤡 swag update mr balon

Offline balon

  • Operations Director
  • 5k Poster
  • *
  • *
  • *
  • Topic Author
  • Posts: 7524
  • Making moves
    • http://steamcommunity.com/id/tjbalon
    • https://twitch.tv/tjbalon
    • https://twitter.com/TangoWorldWide
    • View Profile
  • Liked: 2147
  • Likes Given: 395
  • User Avatar

    tw tj

    Offline


  • Total Badges: 52
    Badges: (View All)
    Slaughter Gang Spammer-50 Goated OG Christmas 2019 Thanksgiving 2019 Halloween 2019 rich boi 5 Year Coin Coby Wizowd Summer 2018 Croc-a-dil 4 Year Coin 12 Days of Christmas 2017 Christmas 2017 Halloween 2017 Roasting Event 2017 Summer 2017 Gstad's Squad Blackhat Fly Shit Only 3 Year Coin Christmas 2016 5000 Posts Thanksgiving 2016 Mobz Award Halloween 2016 The Rich Bitch Summer 2016 Drunk Award 12 Days of Christmas Badge Collector (20) 2 Year Coin aPn's Award Christmas 2015 Spammer-25 Badge Collector (15) Thanksgiving 2015 Halloween 2015 Quick Collector (10) Badge Collector (10) Invisible Quick Poster Mobile User Quick Collector (5) 100 Poll Votes Badge Collector (5) 2500 Posts 1000 Posts 500 Posts
Re: 🔮 Website Data Handling Changes (utf8mb4)
« Reply #5 on: May 12, 2021, 12:36:23 pm »
Fixed a bug where username mentions would become malformed and cause a database error on insert.
-

Offline lance

  • Closed
  • Forum Junkie
  • *
  • Posts: 785
    • https://steamcommunity.com/profiles/76561198443564906/
    • https://www.twitch.tv/troomoo123
    • https://twitter.com/LanceAlanMoore1
    • View Profile
  • Liked: 95
  • Likes Given: 609
  • User Avatar

    lance

    Offline


  • Total Badges: 12
    Badges: (View All)
    Slaughter Gang Badge Collector (10) Stupid Dumb Idiot Face Award Any amongers? 500 Posts 2 Year Coin Badge Collector (5) Spammer-25 100 Posts Quick Poster Mobile User 1 Year Coin
Re: 🔮 Website Data Handling Changes (utf8mb4)
« Reply #6 on: May 12, 2021, 12:42:22 pm »
Fixed a bug where username mentions would become malformed and cause a database error on insert.

Balon is indeed pretty swag coolio for this coding stuff 8)

Offline iNickday

  • Group Staff
  • Forum Regular
  • *
  • *
  • *
  • *
  • Posts: 125
  • Money make the lies feel like the truth
    • https://steamcommunity.com/profiles/76561198009130554/
    • https://www.twitch.tv/inickday
    • View Profile
  • Liked: 5
  • Likes Given: 24
  • User Avatar

    ᵗˢᵇ iNickday

    Online


  • Total Badges: 4
    Badges: (View All)
    100 Posts Brain Dead Quick Poster Mobile User
Re: 🔮 Website Data Handling Changes (utf8mb4)
« Reply #7 on: May 14, 2021, 08:11:17 am »
The update we all wanted 8)

 

G2A Sponsor Image
DigitalOcean
Sinus Bot
AllTrapNation.com
OVH Networks
G2A Sponsor Image
DigitalOcean
Sinus Bot
AllTrapNation.com
OVH Networks