Shulou(Shulou.com)06/03 Report--

In this issue, the editor will bring you about the field data types that can not be sorted. The article is rich in content and analyzes and describes it from a professional point of view. I hope you can get something after reading this article.

The field data type that cannot be sorted is: remarks. Unlike character data, which has a fixed length and no more than 254 characters, memo data is only used to define field types when creating data, and memo fields are used to store text data of varying length.

Remark data can be divided into two types: common remark type (Memo) data and binary preparation type (Memo Binary), and their functions are basically the same.

1. Ordinary Mome, abbreviated as memo.

Unlike character data, which has a fixed length and no more than 254 characters, it is only used to define field types when creating data, and memo fields to store text data of varying length.

The text data can be either a short comment or a long article. In fact, memo fields do not directly store the text itself (otherwise it is no different from character fields), but only pointers to these text.

The contents of the text are stored in a memo file automatically generated by the system with the same name as the table and with the extension: .DCT. Therefore, its length does not need to be very long, and the system stipulates that its length is fixed at 4 digits.

2. Binary Memo Binary, which is the same as the comment type, but its value will change when the contemporary code page changes. It is used for login scripts in different countries, and so on. The reason is the same as the binary character type.

The above is what the editor shares with you about the field data types that cannot be sorted. If you happen to have similar doubts, please refer to the above analysis to understand. If you want to know more about it, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.