title: How to insert chinese characters in sql server database using insert query in stored procedure?
body: <p><strong>Chinese characters are inserting as '??' in table.</strong></p>
  
  <p>I have tried like this but its not working.</p>
  
  <pre><code>CREATE PROCEDURE [Sp_InsertPersonalInformation]
  (
  @NameIn_Chinese  NVARCHAR(100)=NULL
  )
  AS
  BEGIN
      INSERT INTO tbl_PersonalInformation(ChineseName) VALUES (N''+@NameIn_Chinese+'')
  END
  </code></pre>
  
  <p>The below query is working. but through stored procedure i'm not able to insert in a correct format. </p>
  
  <pre><code>INSERT INTO TBL_PERSONALINFORMATION(ChineseName) VALUES (N'你好')
  </code></pre>