Database--The advantages and disadvantages of Chinese table name and field name

Today I understand a function, I found that the database column name is actually Chinese, work more than six years to see. Only remember when school, our teacher said there will be compatibility and other issues, the specific has not been clearly written.

I am a good thing Baidu, finishing up the answers given by the netizens, hope to help everyone.

When we use the table and column names in Chinese, we first confirm whether the database we are using supports Chinese table names and column names. For example, my most commonly used SQL Server, it supports the use of Chinese. Now the mainstream database, multi-lingual support is also increasingly perfect.

Let's talk about the suitable scenes and advantages and disadvantages of choosing Chinese.

Scene :

1, in unfamiliar areas (mechanical, medical and other professional), English is often not accurate translation, and the use of pinyin or abbreviation is not intuitive, rather than direct use of English.

2, in the resume, the rapid opening (low cost for demonstration only) project, often the data dictionary no special requirements, and do not have to consider stability, migration and so on. The use of Chinese can easily modify the logical structure model, convenient for SQL statement design, and in the future can be changed to English text segment name at any time.

Advantages:

1. No need to consider naming conventions

2, it is clear that we want to operate the field, it looks almost at a glance. --Of course, if the database is entered by others, it is clear that security is almost.

3, the page display time without conversion.

4, Add, change field properties, no need to adjust the permanent field. I don't understand that. If anyone understands, please help me, thank you very much.

Disadvantages:

1, writing the Chinese "," and the English ",", Chinese full-width half-width of the switch is too troublesome, very prone to problems.

2, looks a little low, also prone to hit the wrong column name. --Intelligent Input method and the profound language of our country.

3, Chinese storage pre-English storage is different, so some system views may have some performance or maintenance impact. Merging columns is a hassle.

4, poor compatibility . such as multi-language environment, a variety of database conditions , poor compatibility. In Java, the Chinese column name is not supported, and it will directly cause your operation to be unsuccessful.

In general, the use of Chinese names is far more harmful than the advantages. So in order to avoid unnecessary trouble and inexplicable mistakes, the other scenario is to choose English as well.

But what we need to be aware of is:

1, must be named specification.

2, to avoid some names and keywords conflict.

3, consider the interface friendly, the page display must display Chinese.

Database--The advantages and disadvantages of Chinese table name and field name