The character set of the database is chinese_prc_ci_as. Everyone knows that English characters are not case-sensitive, but today I discovered that Chinese punctuation is not divided into full-width and half-width, that is:
,and,
)and)
(and(
The above full-width and half-width are treated the same in sorting and Select conditions.