For an input data file in fixed-size data format, specify the input data in characters or in the format stored in the database. When using a constructor function to generate the data to be stored in an abstract data type, code the input parameter either in character string data or in the data type of the function argument.
For details about how to specify input data in characters, see 5.5.1 DAT format. For details about how to specify input data in the format stored in the database, see 5.5.2 Binary format.
Table 5-19 Data storage when the input data is specified in the character string data format (fixed-size data format)
Data type of table column or parameter data type of constructor function | Specification of column name statement | Data specified in the input data file | Storage data |
---|---|---|---|
INTEGER, SMALLINT, DECIMAL, FLOAT, and SMALLFLT | type=char(3) | 1![]() ![]() | 1 of each data type |
![]() ![]() | |||
![]() ![]() | |||
CHAR(7) and MCHAR(7) | type=char(7) or type=char(7),mode=text | ABC![]() ![]() ![]() ![]() | ABC![]() ![]() ![]() ![]() |
"ABC"![]() ![]() | |||
"ABC![]() ![]() | |||
""ABC"" | "ABC"![]() ![]() | ||
![]() ![]() ![]() ![]() ![]() ![]() ![]() | ![]() ![]() ![]() ![]() ![]() ![]() ![]() | ||
""![]() ![]() ![]() ![]() ![]() | |||
type=char(7),mode=bin | ABC![]() ![]() ![]() ![]() | ABC![]() ![]() ![]() ![]() | |
"ABC"![]() ![]() | "ABC"![]() ![]() | ||
"ABC![]() ![]() | "ABC![]() ![]() | ||
""ABC"" | ""ABC"" | ||
![]() ![]() ![]() ![]() ![]() ![]() ![]() | ![]() ![]() ![]() ![]() ![]() ![]() ![]() | ||
""![]() ![]() ![]() ![]() ![]() | ""![]() ![]() ![]() ![]() ![]() | ||
NCHAR(3) | type=char(6) | ![]() ![]() ![]() | ![]() ![]() ![]() |
"![]() ![]() | "![]() ![]() | ||
"![]() ![]() | ![]() ![]() ![]() | ||
""![]() | "![]() ![]() | ||
![]() ![]() ![]() | ![]() ![]() ![]() | ||
""![]() ![]() | ""![]() ![]() | ||
VARCHAR(7) and MVARCHAR(7) | type=char(7) or type=char(7),enclose_del=yes | ABC![]() ![]() ![]() ![]() | ABC (3 bytes) |
"ABC"![]() ![]() | |||
"ABC![]() ![]() | ABC![]() ![]() | ||
""ABC"" | "ABC" (5 bytes) | ||
![]() ![]() ![]() ![]() ![]() ![]() ![]() | ![]() | ||
""![]() ![]() ![]() ![]() ![]() | (0 byte) | ||
type=char(7),enclose_del=no | ABC![]() ![]() ![]() ![]() | ABC (3 bytes) | |
"ABC"![]() ![]() | "ABC" (5 bytes) | ||
"ABC![]() ![]() | "ABC![]() ![]() | ||
""ABC"" | ""ABC"" (7 bytes) | ||
![]() ![]() ![]() ![]() ![]() ![]() ![]() | ![]() | ||
""![]() ![]() ![]() ![]() ![]() | "" (2 bytes) | ||
NVARCHAR(3) | type=char(6) | ![]() ![]() ![]() | ![]() ![]() ![]() |
"![]() ![]() | "![]() ![]() | ||
"![]() ![]() | ![]() ![]() | ||
""![]() | "![]() | ||
![]() ![]() ![]() | ![]() ![]() ![]() | ||
""![]() ![]() | ""![]() ![]() | ||
DATE | type=char(12) | 2003-12-31![]() ![]() | 2003-12-31 |
![]() ![]() | |||
![]() ![]() | |||
INTERVAL YEAR TO DAY | type=char(11) | 00010101.![]() ![]() | +00010101. |
![]() ![]() | |||
![]() ![]() | |||
TIME | type=char(10) | 08:45:00![]() ![]() | 08:45:00 |
![]() ![]() | |||
![]() ![]() | |||
INTERVAL HOUR TO SECOND | type=char(9) | 010101.![]() ![]() | +010101. |
![]() ![]() | |||
![]() ![]() | |||
TIMESTAMP | type=char(21) | 1991-01-01_11:22:33![]() ![]() | 1991-01-01_11:22:33 |
![]() ![]() | |||
![]() ![]() | |||
BLOB | type=char(13) | /tmp/file01![]() ![]() | Data in /tmp/file01 |
![]() ![]() | Error | ||
![]() ![]() | |||
BINARY(7) | type=char(7) | ![]() ![]() ![]() ![]() ![]() ![]() ![]() | ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
Figure 5-14 shows an example of coding data in the fixed-size data format.
Figure 5-14 Example of data in fixed-size data format