Problem performance:
Open a table in SQL Server Manger Studio, you cannot enter Chinese, you can only enter English
Problem Recurrence:
1. We set up the following three test tables:
CREATE TABLE Ta (
ID int IDENTITY,
Col varchar (50)
)
CREATE TABLE TB (
Col varchar (50),
ID int IDENTITY
)
CREATE TABLE TC (
col1 varchar (50),
Col2 as Col1
)
2. Open these three tables for data entry in SQL Server Manger Studio, and you will find that you can enter Chinese
3. So how did the fault malfunction reappear? To continue the test, in the test table established above, each table has a read-only column, if you move the cursor to the column, and then moved back to the writable column, you will find that the Chinese input method can not be opened.
Conclusion:
When entering data in SQL Server Manger Studio, do not move the cursor to a read-only column, otherwise your Chinese will not want to be entered
Also, when designing a table, it may be noted that if you want to enter Chinese in SQL Server Manger Studio, do not set the read-only column to column 1th, such as the above Test table TA, if you have entered the data, then use SQL Server Manger S Tudio Open, you will find that the cursor is positioned in the 1th record of the 1th column (identity column, but also read columns), which will cause you can not enter the Chinese
This should be a BU for SQL Server manger Studio.
Small tip:
In SQL Server Manger Studio, the read-only column displays the data that is grayed out (slightly lighter than the normal color of the column) and can be distinguished by a closer look.