Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
UTF-8 Coallition Conversion Details »
UTF-8 Coallition Conversion
Mod Version: 1.00, by borbole (Coder/Designer) borbole is offline
Developer Last Online: Oct 2015 I like it Show Printable Version Email this Page

vB Version: 4.1.11 Rating: (3 votes - 4.67 average) Installs: 27
Released: 28 Apr 2012 Last Update: 29 Apr 2012 Downloads: 179
Not Supported DB Changes Uses Plugins  

This tool will convert the character collation of your database to utf-8.

After you install it, go to your Admin Panel->Maintenance->General Update Tools and all the way to the bottom there is a new option added called: UTF-8 Conversion.

Important: MAKE FIRST A BACKUP OF YOUR DATABASE BEFORE YOU RUN THIS TOOL!

If you will need support/assitence with it, please post at the mod 's thread at my forum.

http://www.forumservices.eu/vb/showt...ion-Conversion

Download Now

Only licensed members can download files, Click Here for more information.

Screenshots

Click image for larger version

Name:	acp-conversion.png
Views:	364
Size:	68.0 KB
ID:	138059  

Show Your Support

  • To receive notifications regarding updates -> Click to Mark as Installed.
  • This modification may not be copied, reproduced or published elsewhere without author's permission.
Comments
  #2  
Old 28 Apr 2012, 22:31
thecore762 thecore762 is offline
 
Join Date: Jul 2008
Will test this on my test boards
__________________
www.47r-squad.com BF3|CS:S|TF2|L4D2 Gaming community
Reply With Quote
  #3  
Old 29 Apr 2012, 02:59
Merjawy's Avatar
Merjawy Merjawy is offline
 
Join Date: Sep 2002
Location: USA
will test it.
Reply With Quote
  #4  
Old 29 Apr 2012, 03:10
Boofo's Avatar
Boofo Boofo is offline
 
Join Date: Mar 2002
Real name: Rob
I'd be interested to hear back from anyone who has run this. What will this mod do to a db that already has the collation set to UTF-8?
Reply With Quote
  #5  
Old 29 Apr 2012, 06:25
sadiq6210 sadiq6210 is offline
 
Join Date: Sep 2005
Real name: Sadiq
Thanks .. great to see this again.
I will test it tomorrow and give you my feedback
Reply With Quote
  #6  
Old 29 Apr 2012, 07:12
Merjawy's Avatar
Merjawy Merjawy is offline
 
Join Date: Sep 2002
Location: USA
Well, few minutes ago I tested it on a big forum 4.1.10 (20K users, 25+K threads, close to 100K posts) and everything is still working

I am not so sure if it was actually converted or not, the reason I say that is because I have few java scripts that I expected to have issues with but I didn't !...

I will check everything later today and report as I need some sleep now.

EDIT: Checking db via PhpMyAdmin I see it did convert to UTF8... Thanks

Last edited by Merjawy; 29 Apr 2012 at 07:28.
Reply With Quote
  #7  
Old 29 Apr 2012, 09:29
Emeralda's Avatar
Emeralda Emeralda is offline
 
Join Date: Oct 2011
Real name: Sara
Could someone explain to a total baka (read: bimbo) what this actually does? I'm kinda curious.
__________________
Reply With Quote
  #8  
Old 29 Apr 2012, 10:19
borbole's Avatar
borbole borbole is offline
 
Join Date: Jan 2010
Originally Posted by Merjawy View Post
Well, few minutes ago I tested it on a big forum 4.1.10 (20K users, 25+K threads, close to 100K posts) and everything is still working

I am not so sure if it was actually converted or not, the reason I say that is because I have few java scripts that I expected to have issues with but I didn't !...

I will check everything later today and report as I need some sleep now.

EDIT: Checking db via PhpMyAdmin I see it did convert to UTF8... Thanks
Originally Posted by sadiq6210 View Post
Thanks .. great to see this again.
I will test it tomorrow and give you my feedback
Originally Posted by Merjawy View Post
will test it.
Thank you for testing the mod Merjawy, sadiq6210 and thecore762. Looking forward to hear your results I had tested it thoroughly as well before I released it and it worked fine anytime.


Originally Posted by Boofo View Post
I'd be interested to hear back from anyone who has run this. What will this mod do to a db that already has the collation set to UTF-8?
Boofo, if the db 's database collation character is already set to utf-8 then there is no need to run this tool. But even if it is run, there will happen nothing to the db. I have tested it that way too. However, as adviced in the description, it is always best to first make a backup of the database before you do any changes to it.


Originally Posted by Emeralda View Post
Could someone explain to a total baka (read: bimbo) what this actually does? I'm kinda curious.
Emeralda, this tool will change the database collition character to utf-8. That is ideal if you use other languages in your forum other than english that have special characters that are not used in English. These characters can turn up weird on your website. For example, tremas and umlauts, ... (, , ...) etc.
__________________
My mods.
Reply With Quote
  #9  
Old 29 Apr 2012, 10:49
Boofo's Avatar
Boofo Boofo is offline
 
Join Date: Mar 2002
Real name: Rob
Originally Posted by borbole View Post
Boofo, if the db 's database collation character is already set to utf-8 then there is no need to run this tool. But even if it is run, there will happen nothing to the db. I have tested it that way too. However, as adviced in the description, it is always best to first make a backup of the database before you do any changes to it.
I guess I was referring to running it in case there were a few table that weren't set as UTF-8, for whatever reason. Does this also set the default collation to UTF-8 for the whole db?
Reply With Quote
  #10  
Old 29 Apr 2012, 13:39
Merjawy's Avatar
Merjawy Merjawy is offline
 
Join Date: Sep 2002
Location: USA
I take it back

After checking the site again this morning.. I found few issues
1- Although all tables in db have been converted to UTF-8, the sum at the buttom still shows the total tables are still "latin"

2- Arabic language got totally messed up in Mobile styles

3- when I tried to upgrade to latest release 4.1.12PL1, it hung at 41%, had to rerun upgrade script to get it done.

4- Arabic language with all different settings became garbage (windows-1256 and UTF-8)

I even installed a UTF-8 Arabic file that I use on another site and it didn't display right.

That's my latest report.. I am going back to reload the backup and finish my upgrade.. Thanks anyway.. I will try to play with this again later after I am done with restoring my site and getting it back running.

Regards
Reply With Quote
  #11  
Old 29 Apr 2012, 14:03
borbole's Avatar
borbole borbole is offline
 
Join Date: Jan 2010
Originally Posted by Boofo View Post
I guess I was referring to running it in case there were a few table that weren't set as UTF-8, for whatever reason. Does this also set the default collation to UTF-8 for the whole db?
Yes, that will set the collation to utf-8 for the entire database.

Originally Posted by Merjawy View Post
I take it back

After checking the site again this morning.. I found few issues
1- Although all tables in db have been converted to UTF-8, the sum at the buttom still shows the total tables are still "latin"

2- Arabic language got totally messed up in Mobile styles

3- when I tried to upgrade to latest release 4.1.12PL1, it hung at 41%, had to rerun upgrade script to get it done.

4- Arabic language with all different settings became garbage (windows-1256 and UTF-8)

I even installed a UTF-8 Arabic file that I use on another site and it didn't display right.

That's my latest report.. I am going back to reload the backup and finish my upgrade.. Thanks anyway.. I will try to play with this again later after I am done with restoring my site and getting it back running.

Regards
Thank you for your report. I have tried this tool on several sites, small and medium ones, and I never encountered any issues during my tests. It converted the collation character as it was supposed to and the special characters worked properly.

About the upgrade hang up that you describe, I do not think it is related to my mod as it has nothing to do with that part.

But as long as a database backup is made beforehand then you are covered as you can easily revert back in case of any issues.
__________________
My mods.
Reply With Quote
  #12  
Old 29 Apr 2012, 16:04
sadiq6210 sadiq6210 is offline
 
Join Date: Sep 2005
Real name: Sadiq
I have a forum with +0.5 million posts. I will copy the forum to another database now and start my test for this mod.

BRB
Reply With Quote
  #13  
Old 29 Apr 2012, 17:58
sadiq6210 sadiq6210 is offline
 
Join Date: Sep 2005
Real name: Sadiq
Completed

Actually this product is converting only the structure without the content
After complete try to enter the database from phpmyadmin and read the (post) table, still you cannot read the special characters, what this mod did is the same when you open the database and change the charset for all tables manually.

We need to develop something like this:
http://www.vbulletin.org/forum/showthread.php?t=118308
http://www.vcharset.com/

With that mod you will be able to convert the database to UTF-8 and you can read all the special characters from phpmyadmin which means both structure and content has been converted.
Reply With Quote
  #14  
Old 29 Apr 2012, 21:29
borbole's Avatar
borbole borbole is offline
 
Join Date: Jan 2010
Can you please download the new package that I attached and give it another go?

P.s. Does your forum language support utf-8 btw?
__________________
My mods.
Reply With Quote
  #15  
Old 02 May 2012, 11:35
Morpheus NS Morpheus NS is offline
 
Join Date: Oct 2009
Originally Posted by sadiq6210 View Post
Actually this product is converting only the structure without the content
After complete try to enter the database from phpmyadmin and read the (post) table, still you cannot read the special characters, what this mod did is the same when you open the database and change the charset for all tables manually.
This is true, I was expecting more from this product. It did change the charsets, but content remains the same. Conversion was successful, no problems so far...
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Mod Options

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


New To Site? Need Help?

All times are GMT. The time now is 15:23.

Layout Options | Width: Wide Color: