Character, numerical type, logic, date, date and time type, currency type, what are the effects of these.
1 thought on “People who are familiar with VFP data types come in”
Desiree
Character: character data is generally used to represent text information, such as names, addresses, etc. It consists of letters (Chinese characters), numbers, spaces, and other ASCII characters that can be printed. The length of the character data is 0 to 254, and each character accounts for 1 byte. Chinese characters are also characters, and 1 Chinese characters account for 2 bytes. Character data is represented by C. : Numerous data is generally used to represent quantity, such as scholarships, grades, etc. It consists of numbers 0 to 9, a symbol ( or-), and a decimal point (.). The length of the numerical data is 1 to 20 bits, the accuracy is 16 bits, and each data accounts for 8 bytes. Numerous data is represented by n. The range of numerical data data is: -0. 19-0. 20. Logic type: Logic data is generally used to indicate data with only two values, such as gender (male, female), test scores (passed, not over), etc. The values of the deposit are only two states: true (.t.) And fake (.f.), Occupying 1 byte. Logical data is represented by L. Date type: Date -type data is generally used to indicate the date value without time, such as the year of birth and the date of enrollment. The storage format of the date data is "yyyymmdd", of which YYYY is the year, accounts for 4 places, MM is a month, 2 bits, DDs are day, and 2 digits. Date -type data is represented by D. Date -type data indicates multiple formats, and usually uses American format MM/DD/YYYY (day/month/year). It can be used to change its format in Set Date, Set Century and the Set Mark To command. Date time: Date -time data is used to save the date and time value. Date -time data occupies 8 bytes, the first 4 byte preservation date, and the last 4 byte preservation time. The storage format of the date timing data is "", of which YYYY is the year, accounts for 4 places, MM is a month, 2 digits, DD is the day, HH is the hour in the time, accounts for 2 places, MM is time is time In the minute, 2 bits are occupied, and SS is the second in the time, accounting for 2. Date -type data is represented by T. The date timer data may contain only one date or only one time value. When the default date value, the system automatically adds December 31, 1999; when the time value is omitted, the midnight is automatically added. Currency type: currency data is generally used for currency calculations, such as amounts, etc. When using the currency value, you can use the currency type to replace the numerical type. The currency data only retains only 4 decimal numbers. When the decimal digits exceed 4 bits, the system will process four houses and five entries. Each currency data accounts for 8 bytes. Money -type data is represented by Y. The range of currency data is: -. 5807 ～ .5807, and added a symbol "$" before currency data.
Character: character data is generally used to represent text information, such as names, addresses, etc. It consists of letters (Chinese characters), numbers, spaces, and other ASCII characters that can be printed. The length of the character data is 0 to 254, and each character accounts for 1 byte. Chinese characters are also characters, and 1 Chinese characters account for 2 bytes. Character data is represented by C.
: Numerous data is generally used to represent quantity, such as scholarships, grades, etc. It consists of numbers 0 to 9, a symbol ( or-), and a decimal point (.). The length of the numerical data is 1 to 20 bits, the accuracy is 16 bits, and each data accounts for 8 bytes. Numerous data is represented by n. The range of numerical data data is: -0. 19-0. 20.
Logic type: Logic data is generally used to indicate data with only two values, such as gender (male, female), test scores (passed, not over), etc. The values of the deposit are only two states: true (.t.) And fake (.f.), Occupying 1 byte. Logical data is represented by L.
Date type: Date -type data is generally used to indicate the date value without time, such as the year of birth and the date of enrollment. The storage format of the date data is "yyyymmdd", of which YYYY is the year, accounts for 4 places, MM is a month, 2 bits, DDs are day, and 2 digits. Date -type data is represented by D. Date -type data indicates multiple formats, and usually uses American format MM/DD/YYYY (day/month/year). It can be used to change its format in Set Date, Set Century and the Set Mark To command.
Date time: Date -time data is used to save the date and time value. Date -time data occupies 8 bytes, the first 4 byte preservation date, and the last 4 byte preservation time. The storage format of the date timing data is "", of which YYYY is the year, accounts for 4 places, MM is a month, 2 digits, DD is the day, HH is the hour in the time, accounts for 2 places, MM is time is time In the minute, 2 bits are occupied, and SS is the second in the time, accounting for 2. Date -type data is represented by T. The date timer data may contain only one date or only one time value. When the default date value, the system automatically adds December 31, 1999; when the time value is omitted, the midnight is automatically added.
Currency type: currency data is generally used for currency calculations, such as amounts, etc. When using the currency value, you can use the currency type to replace the numerical type. The currency data only retains only 4 decimal numbers. When the decimal digits exceed 4 bits, the system will process four houses and five entries. Each currency data accounts for 8 bytes. Money -type data is represented by Y. The range of currency data is: -. 5807 ～ .5807, and added a symbol "$" before currency data.