Ytukyg

C# code:

using (SqlCommand myCommand = new SqlCommand("My_StoredProcedure", myConnection))

{

    myCommand.Parameters.AddWithValue("@Parameter","Quản trị");

}

Stored procedure:

ALTER PROCEDURE [dbo].[My_StoredProcedure] 

    (@Parameter NVARCHAR(MAX))

Things I tried:

• 
  

  Changed AddWithValue in order to set SqlDbType.VarChar as below

  
  
  

  myCommand.Parameters.AddWithValue("@Parameter", SqlDbType.VarChar).Value = "Quản trị";
  
  

  
  


• 
  

  Then changed stored procedure parameter type to varchar as below

  
  
  

  ALTER PROCEDURE [dbo].[My_StoredProcedure]
  
      (@Parameter VARCHAR(MAX))
  
  

  
  

Question:

Things I tried did not work to shown correct text value. Text always appears as Qu?n tr? in the stored procedure side.

If I try below this works but this is not what I want. I want to add "N" prefix from code (C#) side. So I'm not sure how to achieve this.

ALTER PROCEDURE [dbo].[My_StoredProcedure]

    (@Parameter NVARCHAR(MAX) = N'Quản trị')

What kind of solution should I apply in C# or SQL Server?

Any help will be appreciated.

Thank you

I would keep the data type in SQL as an NVARCHAR because that is what it should be and the C# code should like this:

myCommand.Parameters.Add("@Parameter", SqlDbType.NVarChar).Value

You have passed in VarChar instead of NVarChar so it makes sense for Unicode not to display.