14.5.2 Output rules for output data
-
The character encoding of the data stored in the table is used for output to the output data files.
-
Each row of data is exported to one row in the file.
-
The line break code is output at the end of each line. The line break code is X'0A' (LF).
-
The maximum length of a row of output data is 512 megabytes (536,870,912 bytes). If a row exceeds 512 megabytes, a file output error will occur.
-
Character string data, datetime data, and binary data are enclosed between the enclosing character and then output.
-
The delimiter is output between field data items.
-
If the --with-column-name option is specified, the column name is output in the first line in the file. The output format of each column name is the same as that of VARCHAR type data.