Unable to enter Chinese in SQL Server manger Studio

Source: Internet
Author: User
Tags sql

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.



Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.