Songstuff Posted January 23, 2015 Share Posted January 23, 2015 HiWhen my server was set up the admin set up the MYSQL database as latin1_swedish_c1.I understand the database, tables and columns will be set this way, as will stored data.What is the best way to convert it to UTF8 and set that as the default?The forums are mid sized. I discovered the issue when preparing to move hosting from an apache linux set up to a windows IIS set up. During testing I received driver errors when rebuilding the html and rebuilding the skins, and when running diagnostics on database checker and database index checker I get a simple "page cannot display" message.I don't know for sure that the collation issue is directly causing this, but I do recognise that it can be a serious issue.Can anyone help? What queries should I run to fix this?CheersJohn Link to comment Share on other sites More sharing options...
RevengeFNF Posted January 25, 2015 Share Posted January 25, 2015 What is the best way to convert it to UTF8 and set that as the default?http://community.invisionpower.com/files/file/6823-ips-utf8-database-converter/ Link to comment Share on other sites More sharing options...
Songstuff Posted January 27, 2015 Author Share Posted January 27, 2015 Many thanks, all sorted Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.