I need to run a BCP export from a db for an external client. The stored proc is pre-written. When I try and output the file to csv, I get this error
Error = [Microsoft][SQL Server Native Client 10.0]This version of SQL Server Native Client does not support UTF-8 encoding (code page 65001)
SQL Server 2016 running at compatibility 130.
Drivers 10.0,11.0,13,18 are all installed on the server. I've tried reinstalling Driver 11.0 I've tried disabling 10.0 in SQL server management console Both 10 and 11 Drivers seems to be available in the registry
It may be my misunderstanding of how drivers work but I thought SQL Server 2016 would need to use 11.0 by default.
I'm hoping someone can point me in the right direction. Thanks in advance.