bcp out: bcp exports an empty string (not null) and writes nul in the file

Question

This is the data in the table

Use bcp out to export data,Export empty string as nul,and Decimal type data (0) loses the first 0，How to make the empty string not be exported to null, and the decimal number '0' does not lose the first 0?

Answer 1

BCP was originally designed to move data between SQL Server databases. And it that is what you are doing, then it does not really matter what you get. The NUL characater will become an empty string when you import it etc.

If you want a certain format when you extract data with BCP, you need to convert it to strings with the desired format in your query. But since you have a C++ program already, it's probably better to just run a query and format client-side.

Answer 2

Probably you see the data in different order. To avoid confusions, try some unique values in the first column, like 50, 51, 52.

How did you get the second image? Maybe 0 is displayed as .00 by the viewer, but the file contains 0. Did you use a simple text editor like Notepad? Give some details.