In the process of program development, sometimes you need to directly input data testing programs in the database.
If you enter Chinese characters directly in a table in the Microsoft SQL Server database, you may not be able to enter Chinese characters,
This seems to be a small BUG. It has been tested several times, and there are several situations below.
1. if you define a field in the table as INT or BIGINT and place this column in the first column, open the table and enter Chinese Characters in other fields
You cannot enter Chinese characters.
2. If the field in the first column of the table is not an INT or BIGINT column, you can enter Chinese Characters
Conclusion: When a database table is opened, the cursor position is in the first column by default. If this column is INT or BIGINT
You cannot enter Chinese Characters in other non-INT or BIGINT columns.
Solution: place the INT or BIGINT column in the non-first column or change the INT or BIGINT column to a non-INT or BIGINT column.