Answers for "mysql change default collation"

mysql modify default value

ALTER TABLE tbl_name ALTER column_name SET DEFAULT new_value;

Posted by: Guest on July-20-2021

mysql change default collation

//Server side, so every new table will be utf8 unicode

SET character_set_server = 'utf8';
SET collation_server = 'utf8_unicode_ci';

Posted by: Guest on November-18-2021

Code answers related to "mysql change default collation"