SQL statement used in SQL Server to calculate the number of Chinese characters in a string

On this topic, I also see other methods on the Internet to solve the problem.
However, from the perspective of performance and code volume, I have a better solution.
Here we will share with you.
The principle is actually very simple,
Knowledge 1. Length function len ();
Knowledge 2, or the length function datalength ();

The Code is as follows:
Copy codeThe Code is as follows: declare @ SQL varchar (1000)
Set @ SQL = 'abc country m, de China d country e people F'
Select @ SQL character, DATALENGTH (@ SQL)-len (@ SQL) Number of Chinese Characters