In mysql, how does one determine whether a mysql field contains Chinese characters?

Use two functions: length and char_length.

Length: the length of a calculated field. A Chinese character is counted as three characters. A number or letter is counted as one character.

Char_length: whether it is a Chinese character, a number, or a letter.

Use length and char_length for the same field to calculate the length. If the length is the same, the field does not contain Chinese characters. If the length is different, there must be Chinese characters.

Copy codeThe Code is as follows:
SELECT
*
FROM
T_ad t
WHERE t. 'userid' = 974
And length (
REPLACE (t. 'title', '-', ''), '+ ','')
) = 3 * CHAR_LENGTH (
REPLACE (t. 'title', '-', ''), '+ ','')
)
AND t. 'deletegroup' = 1;