Bcp Fails To Export With Error "unable To Resolve Column Level Collation"

I've thoroughly searched Stack Overflow as well as many other resources but still have an issue. Here's my export script, running under Cygwin: #!/usr/bin/env bash #-*- coding: cp1

Solution 1:

Have you tried using the -C switch to specify a specific code page?

Here's the BCP syntax page from Books Online:

http://msdn.microsoft.com/en-us/library/ms162802.aspx

Looking here, it looks like you may want to use code page 1255:

http://msdn.microsoft.com/en-us/library/ms186356(v=sql.105).aspx

HTH.