*Only the t, n, r, 0 and '\0' characters work with the backslash escape character to produce a control character. String of up to 10 printable characters, including some or all of the terminators listed earlier Null terminator (nonvisible terminator)**Īny printable character (control characters are not printable, except null, tab, newline, and carriage return) The following table lists the supported characters for terminators. The bcp command, BULK INSERT statement, and the OPENROWSET bulk rowset provider support a variety of characters as field or row terminators and always look for the first instance of each terminator. Native format data can conflict with terminators because a native-format data file is stored in the MicrosoftSQL Server internal binary data format. When you use native or Unicode native format, use length prefixes rather than field terminators.
0 Comments
Leave a Reply. |