SHOW DATABASES LIKE ‘tech%’;
CONCAT (string1, string2, string3)
SELECT SUBSTR(title, 1, 10) from techpreparation_questions;
The first is, naturally, the character count. The second is byte count. For the Latin characters the numbers are the same, but they’re not the same for Unicode and other encodings.
SELECT (techpreparation_question USING utf8);