An example to use a collation at the database level different from that at the instance level - storing the Chinese characters

--The server instance collation: SQL_Latin1_General_CP1_CI_AS
--The database collation: Chinese_PRC_CI_AI

CREATE TABLE 名字
    (
      fname NVARCHAR(35) NOT NULL ,
      lname NVARCHAR(30) NOT NULL
    )
GO

INSERT  名字
VALUES  ( '', '' ),
        ( '', '' ),
        ( '', '' ),
        ( '', '' )

SELECT  [fname] ,
        [lname]
FROM    [dbo].[名字]
ORDER BY fname

/***returned result***
fname          lname
            
            
            
            
********************/