SQL Server supports hard text in gb18030

Create a database, select chinese_prc_90_ci_ai as the sorting rule of SQL Server 2005, and select chinese_prc_100_ci_ai as the sorting rule of SQL Server 2008.

 

If you do not select this rule, use the default chinese_prc_ci_ai.

Select * From DBO. lexicon where title = n' Yu'

There is a result of the "mackerel '"

Select * From DBO. lexicon where title = n' Yu'

No results

This is because the default rule does not match "hidden" and is ignored as invisible characters.

 

Idea Source: http://blogs.msdn.com/ B /qingsongyao/archive/2009/02/24/gb18030-character-set-support-in-sql-server.aspx