Questions about SQL Server failing to query Chinese

The version of SQL Server is 2016, and you randomly try a query with a WHERE clause. As follows:

Select *  from  wherelike'% system%'

Na, how not to find out, clearly there should be several.

Does SQL Server not support fuzzy queries? It's not possible, after all, it's version 2016.

So just try to use wildcard characters to query, there is the result.

Replace the Chinese part of the SQL statement with the appropriate English, with the result.

Estimation is the evil of the coding problem, first on the search engine, got a solution, as follows:

Select *  from  where like N'% system%'

Try, the query results are normal.

The problem is also mentioned on Microsoft's website:

https://support.microsoft.com/en-us/kb/239530

Questions about SQL Server failing to query Chinese