View the view with Chinese
Select a.name,a. [type], b. [definition] from sys.all_objects a,sys.sql_modules b
Where a.is_ms_shipped=0 and a.object_id = b.object_id and a. [type] in ('V')
And b. [definition] LIKE nasty% [A-L]% 'COLLATE Chinese_PRC_CI_AS
Order by a. [name] asc