問題文
A column that stores a country code is declared as a fixed length character type of five positions. A row supplies a value of two characters. What does the column hold afterwards and how does a comparison behave?
選択肢
- The value is padded with zeroes to five positions and a comparison ignores the padding on both of the sides.
- The value is stored as the two characters supplied and a comparison with a shorter literal treats the two as different values.
- The value is rejected and the column requires exactly five characters in every row that the table holds.
- The value is padded with blanks to five positions and a comparison with a shorter literal still treats the two as equal.