> > >

MySQL MCQs

Which of the following is the correct way to change the character set to UTF8?

Add the following lines in my.cnf: [client] default-character-set=utf8 [mysqld] default-character-set = utf8

Add the following lines in my.cnf: [mysqld] character_set_server = utf8

Add the following lines in my.cnf: [mysqld] skip-character-set-client-handshake character_set_client=utf8 character_set_server=utf8

Add the following lines in my.cnf: [mysqld] init_connect='SET collation_connection = utf8_unicode_ci' character-set-server = utf8 collation-server = utf8_unicode_ci [client] default-character-set = utf8

Answer

Correct Answer: Add the following lines in my.cnf: [mysqld] init_connect='SET collation_connection = utf8_unicode_ci' character-set-server = utf8 collation-server = utf8_unicode_ci [client] default-character-set = utf8

Explanation:

Note: This Question is unanswered, help us to find answer for this one

MySQL Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it