Change database character encoding?

Replies

• 

  Mahesh Dahale

  Try this simple SQL query
  
  

  ALTER TABLE tablename CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
  

• 

  Kaustubh Katdare

  mahesh_dahale

  Try this simple SQL query
  
  

  ALTER TABLE tablename CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
  

  Yep - however that messed up my wordpress database 😔 .
• 

  Mahesh Dahale

  Sorry for that 😔 see these links
  
  #-Link-Snipped-#
  
  #-Link-Snipped-#
• 

  Kaustubh Katdare

  I guess I'm going to perform a second test soon. Will keep this thread updated.
  
  Thanks for the links, Mahesh 😀