In mysql, how does one determine whether a mysql field contains Chinese characters?
In mysql, how does one determine whether the current character is mysql?
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.
SELECT * FROM t_ad t WHERE t. 'userid' = 974 and length (REPLACE (t. 'title', '-', ''), '+','') = 3 * CHAR_LENGTH (REPLACE (t. 'title', '-', ''), '+','') AND t. 'deletegroup' = 1;
The preceding figure shows how mysql judges whether the current character mysql determines whether the field contains the Chinese character _ MySQL content. For more information, see PHP Chinese website (www.php1.cn )!