NoGi Posted December 2, 2014 Share Posted December 2, 2014 2 quick questions as I have a 3.4.7 database that is currently utf8mb4 with the tables as utf8_general_ci - yes not ideal but trying to work out the best way to resolve.What's prefered for IPS4 - utf8mb4 or utf8_general_ci?And, what's the best way to make my database and tables the same? Link to comment Share on other sites More sharing options...
Mark Posted December 2, 2014 Share Posted December 2, 2014 IPS4 requires the collation across the database to be either utf8_unicode_ci or utf8mb4_unicode_ci. utf8mb4 is a superset of utf8, so it is "better".You can convert using this script: http://community.invisionpower.com/files/file/6823-ips-utf8-database-converter/ Link to comment Share on other sites More sharing options...
NoGi Posted December 2, 2014 Author Share Posted December 2, 2014 So, having utf8mb4 as the default is fine and I can use the converter to convert from utf8_unicode_ci to utf8mb4_unicode_ci? Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.