Welcome to the [HSX] website!

Been Gaming since 2003

Community Driven Site

Gaming, Web Development, and Support

  

 
Main Menu
 
DFG
 Home
 Join our Clan
 [HSX] Roster
 Forums
 News
 Downloads
 News Letter
 Video tutorials
 Supporters
 Uploads
 F.A.Q
· FAQ
· Docs
· Forums FAQ
 [HS] Timeline
 Site Map
 Write a Review
 Image Repo
 WhoIs
 Twitch ID Finder
 Logout
DFG
DFG DFG DFG

 
[HSX] Donations
 
DFG
Total Donators
Total:
$0.00
Goal:
$30.00
Difference:
$30.00
DFG
DFG DFG DFG

 
Theme Management
 
DFG
DFG
DFG DFG DFG

 
Whos Been
 
DFG
 coRpSE
 3 hours ago
 Lonestar
 8 hours ago
 fire
 13 hours ago
 PatPgtips
 20 hours ago
 2xTaz
 2 days ago
 Spartacus1968
 2 days ago
 EmeraldDragon
 2 days ago
 Grmm
 3 days ago
 bairdboy
 5 days ago
 Bulldog1
 5 days ago
DFG
DFG DFG DFG

 
Survey
 
DFG What is your favorite game to play ATM?

WarThunder
World of Tanks
H1Z1
MechWarrior Online
ARK
WarFace
SWTOR
BattleField serier
COD Series
Diablo
Armored Warfare



Results
Polls

Votes 1610
Comments: 0
DFG
DFG DFG DFG

 
Honey Pot
 
DFG
Bots in the pot!
We have [2706] bots stopped!
HeadShotDomain
DFG
DFG DFG DFG

     
DFG
 
Forum Index Members Search Usergroups
Ranks Staff Statistics Forum FAQ
Board Rules Edit your profile Login, Check Messages Log in
 

[ITW] Character & Collation converter script
Post new topic Reply to topic printer-friendly view List users that have viewed this topic Forum Index In-The-Works
View previous topic View next topic
PostPosted: Fri Oct 30, 2020 3:45 pm Reply with quote
coRpSE
For many of you, if you are a site owner, especially and Evo site owner, you will need this, but you don't know it yet. Just recently, I noticed an error in my database when I ran an SQL, and upon research of this error, I found that uft8, which is the character set that Evo uses, is depreciated in MySQL 8.0, and will be removed in the future.

Well, you may think, "Well coRpSE, didn't you already make a conversion script to change the character set and the collation of a database?". The answer is yes, yes I did. "Well, cant we just use that, and the answer is yes and at the same time, no.

What do I mean by that? Well, you can use it but no all tables will be affected. The reason for this is, any table that has a key value using varchar(255) will throw an error, because utf8mb4 uses 4 bytes for each character, vs utf8 which used 3 bytes. Well, varchar can only have a maximum of 1000 bytes, so 255 x 4 = 1020 which is over the allowed 1000. To fix this, you have to edit each varchar to be 250 instead of 255. 250 x 4 = 1000. So what was once varchar(255) now needs to be varchar(250). That conversion script I made before will not change the varchar since I am not sure if it's even possible to distinct if the table is using varchar(255).

Now, if you followed that is the slightest, then you have to understand that I now had to go through the default DB of Evo, and find all the varchar(255), and write each individual update. I think there was something like 137 of them, then I have a few others. I also had to find away around several other issues that have come up. Well, the status of the update script is, I am about 90% done with it. I put in about 10 hours on it yesterday researching, and trying different things, and today, doing a bunch of individual calls. I am hoping to maybe be done with it in a couple of days. There is no rush because utf8 will still be around for a while, but, I rather get this done now, than later.

If your interested in getting your site updated, follow this post because I will be doing a video with it because of the complications that can occure.


Expand

Top Dog
Nuke Dev / Coder
Clan Leader
Groups Top Dog
Nuke Dev / Coder
Posts 2454
Joined Jan 12, 2012
Status Offline
View user's profile Send coRpSE a private message Visit user's website
coRpSE
Currently Offline
Offline

Most Played:
This week: 7.6hrs.
Total Played: 9.3hrs.


  
Are you really committed?
Find all posts by coRpSE

Display posts from previous:
Post new topic Reply to topic printer-friendly view List users that have viewed this topic All times are UTC - 7 Hours [DST enabled]
Page 1 of 1


 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum

Powered by phpBB © 2001, 2019 phpBB Group
DFG
DFG DFG DFG
Forums ©
Copyright © HeadShotDomain 2016 By: coRpSE
SimpleBlack V2 By: Killigan
Powered By: Evolution-Xtreme