Character format (-c) uses the char datatype for all columns. It inserts tabs between fields in each row and a newline terminator at the end of each row.
For example, the following command copies out the data from the publishers table in character format to the file pub_out:
bcp pubs2..publishers out pub_out -c
The command produces the following bcp output:
0736 New Age Books Boston MA 0877 Binnet & Hardley Washington DC 1389 Algodata Infosystems Berkeley CA
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
