> > >

MySQL MCQs

Which of the following SQL statements will change the table default character set and all character columns (CHAR, VARCHAR, TEXT) to a new character set?

ALTER TABLE tbi_name MODIFY latin1_text_col TEXT CHARACTER SET utf8;

ALTER TABLE tbl_name CONVERT TO CHARACTER SET charset_name;

ALTER TABLE t MODIFY latin1_varchar_col VARCHAR(M) CHARACTER SET utf8;

None of the above.

Answer

Correct Answer: ALTER TABLE tbl_name CONVERT TO CHARACTER SET charset_name;

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