Brothers who have research on the garbled problem come in

德鲁伊

Is the @username procedure parameter in a stored procedure of type varchar or nvarchar? If it's not n, try it again.

waxiaoning

"exec procedure name, @username procedure parameter = N '??????" "?

waxiaoning

Specify encoding on the page

寒雪鸣

Using hashtable to pass parameters to stored procedures

kolerk

to:德鲁伊
Procedure parameter is nvarchar

In addition, such an interesting phenomenon was found during the monitoring of sql server profiler:
Asp.net's built-in controls query the database, when the stored procedure is executed, the database will automatically add N to the parameter whose parameter type is nvarchar during execution, so the above problems will not be encountered.
This means that when the stored procedure I wrote is executed, the database will remove the N that should be added, so it will cause garbled characters.

Jingxiong reminded that the final solution is to compose a sql statement in the website program, add N to the statement, and then execute it.

However, the problem is still to be studied.

kolerk

Procedure parameter is nvarchar

In addition, such an interesting phenomenon was found during the monitoring of sql server profiler:
Asp.net's built-in controls query the database, when the stored procedure is executed, the database will automatically add N to the parameter whose parameter type is nvarchar during execution, so the above problems will not be encountered.
This means that when the stored procedure I wrote is executed, the database will remove the N that should be added, so it will cause garbled characters.

Theshenmue024brother reminded that the final solution was to compose a SQL statement in the website program, add N to the statement, and then execute it.

However, the problem is still to be studied.