Data Types
Character data types
Interger data types
String data types
Real data types
Boolean data types
My Research:
- A data type representing single text characters like the alphabet, numeral digits, punctuation, etc.
- To store alphanumeric text, such as letters, numbers, spaces, symbols, and puncturation, use the Character data type.
- Character fields or variables and Character (Binary) fields can store text imformation that is not used in mathematical calculations, such as names, addresses, and numbers. For example, phone numbers or zip codes, though they include mostly numbers, are actually best stored as character values.
- The character data type basically represents individual or single characters.
- Characters comprise a variety of symbols such as the alphabet (both upper and lower case), the numeral digits (0 to 9), punctuation, etc. All computers store character data in a one byte field as an interger value. Because a byte consists of 8 bits, this one byte field has 28 or 256 possibilities using the positive values of 0 to 255.
- Character data is placed in the database using the exact binary representation that is passed from the application. This usually means that character data is stored in the database with the binary representation of the character set used by your system
- Character data is placed in the database using the exact binary representation that is passed from the application. This usually means that character data is stored in the database with the binary representation of the character set used by your system
- Most microcomputers use the ASCII (stands for American Standard Code for Information Interchange and is pronounced "ask-key") Character Set which has established values for 0 to 127. For the values of 128 to 255 they usually use the Extended ASCII Character Set. When we hit the capital A on the keyboard, the keyboard sends a byte with the bit pattern equal to an integer 65. When the byte is sent from the memory to the monitor, the monitor converts the integer value of 65 to into the symbol of the capital A to display on the monitor.
Resources:
1 - 2 - 3 - 4
Data Operators
Relational Data Operators
Logical Data Operators
Arithmetic Data Operators
My Research:
A relational operator is a programming language that constructs or operates a test or defines some kind of relation between two entities. Or in other words, a relational operator are simple data operators that perform comparisons between their operands. These include numerical equality (e.g., 5 = 5) and inequalities (e.g., 4 ≥ 3)
Different comparisons: relational-operator =equality-operator / inequality-operator / less-than-operator / greater-than-operator / less-than-equal-operator / greater-than-equal-operator
An expression created using a relational operator forms what is known as a relational expression or a condition. Relational operators are usually written in infix notation, if supported by the programming language, which means that they appear between their operands (the two expressions being related). For example, an expression in C will print the message if the x is less than y:
Resources: 1 - 2
