24/7 U.S. Support – 877-595-4482
The following mini script is used to convert existing database tables to UTF-8. Upload the script to your account as "convert.php" and modify the database connection parameters and the character set, then execute the script.To execute the script, you simply would visit the script in any web browser. If you upload the file to your public_html folder you'd visit http://yourdomain.com/convert.php. Dont forget to replace yourdomain.com with your actual domain name.
Of course, you can use this script to change the database to any character set you wish. You need to define the character set in the script to change character sets:
$char_set = 'character set';
You will need the change the utf8_general_ci to match the character set you defined in the step above. So if you wanted to change the character set to hebrew you'd change the line to:
$sql = "ALTER TABLE $table DEFAULT CHARACTER SET $char_set COLLATE hebrew_general_ci";
For more information on MySQL character sets and collation please see the following link:
If you need further assistance please feel free to contact our support department.
|Email:||support@WebHostingHub.com||Ticket:||Submit a Support Ticket|
|Chat:||Click To Chat Now|