toyzonline Posted June 14, 2015 Share Posted June 14, 2015 After doing my 30 day security check I am getting the usual admin http authentication (although I do have the extra password set up to get to admin). However I also have the following: Some database tables need to be converted to UTF-8 (utf8_unicode_ci). Please review the tables under Tools -> Database Tables. Not being totally savvy I am wondering if taking this action could cause any problems with the current set up or database structure Ricardo Complete Newbie On The Learn - Not A Programmer But Learning As I Go Link to comment Share on other sites More sharing options...
Roaddoctor Posted June 14, 2015 Share Posted June 14, 2015 go to Tools -> Database tables, select the tables that are not UTF-8, at the lower right, select Convert to UTF-8, press Go. Fixed BACKUP FIRST - JUST IN CASE -Dave Link to comment Share on other sites More sharing options...
MrPhil Posted June 14, 2015 Share Posted June 14, 2015 Not being totally savvy I am wondering if taking this action could cause any problems with the current set up or database structure In the long run, you're much better off if all of your database is the same encoding (and collation, for sorting purposes) and the page display is the same encoding. If you mix encodings (e.g., Latin-1 and UTF-8), even for an English-only site, you risk having UTF-8 characters eventually showing up as strings of odd accented characters, or an accented character showing up as a ?-in-black-diamond. If the collations do not match everywhere, you risk getting error messages about mismatched sorting order. Take the time to clean up everything and get consistent, and it could save you some headaches down the road. Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.