Character format

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