Question

What is used to produce a new string from an old string in the desired character set?

(a) Introducers

(b) CONVERT()

(c) CONVERTER()

(d) CONVERTS()

I had been asked this question by my school teacher while I was bunking the class.

The query is from Data Value Categories in portion Data Types of MySQL

Answer 1

Right option is (b) CONVERT()

Explanation: The introducers and CONVERT() clause are not the same in MySQL. An introducer modifies the way a string is interpreted and does not modify the string. CONVERT() produces a new string from the old one.