Chinese characters cannot be entered in SQL Server database tables

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.