sql server - Difference between BCP versions. On example of exporting data -

i facing problem bcp (bulk-copy program) on mssql-server 13.0. here goes:

i trying export data program file corrupted. exporting .zip file. works perfect on mssql-server 11.0 - same command can export zip file need export.

command using export:

bcp "select query" queryout "c:\export\myzip.zip" -t -s server_name 

tried use -v flag, didnt work.

---

edit 1: after command used bcp shows me questions prefix, format , etc - using: 0 0 (space) n

---

edit 2: starting bytes of exported file are: 37 7a bc af 27 1c

looking here file signature, appears 7-zip file format. afaict file exported correctly. extension .7z though, not .zip.

you can see here if search starting bytes 37 7a bc af 27 1c.