SQLServer uses varchar field type Chinese garbled

xiaoxiao2021-03-06  56

Today, friends have encountered a problem, and 2 Chinese displayed in the same page records a normal, a garbled, and 2 records are removed from different tables. Use direct entry when you are entered. Carefully observe the difference between the two, find that the field that can be displayed nvarchar is nvarchar in the table, cannot be VARCHAR, trying to be NVARCHAR, problem solving.

Because it is not familiar with SQL Server. Through the query manual:

NVARCHAR represents data stored in Unicode format, so it can display Chinese, and varchar is used to store data with non-Unicode, so garbled.

转载请注明原文地址:https://www.9cbs.com/read-114679.html

New Post(0)