Strings may be enclosed in single quotes or double quotes. Input lines are assumed to be characters, one row per line, with column values separated by delimiters. You canĪlso specify the input format in Interactive SQL by clicking Tools » Options » Import/Export and specifying either Text or Fixed in the Default Import Format field. If the FORMAT clause is not specified, then the input_format option sets the format. Use the FORMAT clause to specify the format of the input file. With ESCAPES turned off, the characters are read exactly as they appear in the source. With ESCAPES turned on (the default), characters following the escape character are interpreted as special charactersīy the database server. For example, to use the exclamation mark as the escape The escape character can be changed using the ESCAPE CHARACTER clause. For example, \q is interpreted as a backslash A backslash followedīy any character other than n, x, X, or \ is interpreted as two separate characters. A sequence of two backslash characters ( \\ ) is interpreted as a single backslash. Other characters can be specified using hexadecimal ASCII codes, such as \x09įor the tab character. The newline character can be specified as \n. For example, \x0A is the linefeed character. The default escape character for hexadecimal codes is a backslash (\). If the input file was created using the OUTPUT statement and an encoding was specified, then the same ENCODING clause should
#Send anywhere asking for input key windows#
On English Windows computers, the default encoding is 1252 or 850. The default encoding for the computer you are running on. If the file has a byte-order mark, the appropriate Unicode encoding is used. The encoding specified by the default_isql_encoding option (if this option is set). The encoding specified by the ENCODING clause (if this clause is specified). When running Interactive SQL, the encoding that is used to import the data is determined in the following order: The ENCODING clause can only be used with the TEXT and SHAPEFILE The encoding argument specifies the encoding that is used to read the file. The DELIMITED BY clause allows you to specify a string to be used as the delimiter between column values in TEXT inputįormat. Use the CREATE TABLE clause to specify whether to create the destination table if it does not exist. If COLUMN WIDTHS is not specified, the widths are determined by the database column types. The COLUMN WIDTHS clause specifies the widths of the columns in the input file and can only be specified for FIXED format. The input data, encoding on the client computer is used.
If the BYTE ORDER MARK option is ON and you specify a UTF-16 encoding with an endian such as UTF-16BE or UTF-16LE, Interactive.To use the BYTE ORDER MARK clause with any other encoding causes an error. The BYTE ORDER MARK clause is used only when reading or writing files encoded with UTF-8 or UTF-16 (and their variants). With FORMAT clauses other than TEXT causes an error. Attempts to use the BYTE ORDER MARK clause The BYTE ORDER MARK clause is relevant only when reading from TEXT formatted files. Use this clause to specify whether to process a byte order mark (BOM) in the data. NAME is allowed only for those formats that have name information in the file. On their ordinal position in the list (ORDER being the default) or by their names (NAME). Use this clause to specify whether the columns from the input file should be matched up with the table columns based
0 kommentar(er)
