How to insert chinese characters in sql server dat

问题:

Chinese characters are inserting as '??' in table.

I have tried like this but its not working.

CREATE PROCEDURE [Sp_InsertPersonalInformation]
(
@NameIn_Chinese  NVARCHAR(100)=NULL
)
AS
BEGIN
    INSERT INTO tbl_PersonalInformation(ChineseName) VALUES (N''+@NameIn_Chinese+'')
END

The below query is working. but through stored procedure i'm not able to insert in a correct format.

INSERT INTO TBL_PERSONALINFORMATION(ChineseName) VALUES (N'你好')