bcp 命令执行不连贯
我在2台计算机上执行bcp命令。第一台计算机有 Windows XP,第二台计算机有 Windows Server 2003。当我在第一台计算机上执行命令时,bcp 成功运行,但是当我在第二台计算机上运行此命令时,出现此错误:
Starting copy...
SQLState = S1000, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver][SQL Server]Code page 720 is not supp
orted by SQL Server
SQLState = S1000, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]Unable to resolve column level collat
ions
BCP copy out failed
问题是什么?
I execute a bcp command in 2 computer. The first computer has windows xp and second one has windows server 2003. when I execute command in first, the bcp run successfully but when I run this on second one, occur this error:
Starting copy...
SQLState = S1000, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver][SQL Server]Code page 720 is not supp
orted by SQL Server
SQLState = S1000, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]Unable to resolve column level collat
ions
BCP copy out failed
what is the problem?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
您可以查看以下文章并使用 BCP 语句中的开关。
在不同排序规则之间复制数据
You might take a look at the following article and play with the switches in you BCP statement.
Copying Data Between Different Collations