Sql server bcp export binary in csv, How do I replace it with ''?"

Question

I have a table that has an empty composition

when exporting it with bcp, it exports it in the following way; with the character "?"

bcp  table out table.csv -S local -U sa -d BD -c -t '|'

some solution to this problem, from bcp

Answer 1

Had the same problem and solved with

 -k

Hope it works for you too ;)

Well, of course it won't work... those field are set not to be NULL. You should change that. If you want the data still not to be NULL you should add a standard value for NULL elements from table

select case 
      when user_Name is null then "default value" 
      else user_name 
   end  

Answer 2

use:

-c -C65001 -t -r"\n" -T -S;

or:

  -k