检查 BCP .dat 文件的简单方法？
我在导入期间收到 BCP 错误“BCP 数据文件中遇到意外的 EOF”，这可能具有误导性。我强烈怀疑某些字段已添加到表中或者文件中存在一些违规字符。
我将如何直观地检查 .dat 文件的内容？
是否有任何好的十六进制查看器，我可以快速尝试调整行长度以以表格方式查看数据？
其他建议也值得赞赏。
I'm getting BCP error "Unexpected EOF encountered in BCP data-file" during import, which is probably misleading. I strongly suspect that some field has been added to the table or there's some offending character is in the file.
How would I go about inspecting the contents of .dat file visually?
Are there any good hex viewers where I can quickly try to adjust row length to see the data in tabular manner?
Other suggestions are also appreciated.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
我想这取决于你的输入格式。是二进制输入吗？如果是这样，那就很难了。我使用 Visual Studio 在二进制查看器中打开文件，但这远非易事。通常的嫌疑是文本字段中的 CRLF 或包含字段分隔符或 EOL 字符的文本。
I guess it depends on your input format. Is it binary input? if so, it's gonna be hard. I use visual studio to open a file in the binary viewer but it's far from easy. The usual suspects are CRLF's in a text field or text that contains your field delimiter or EOL character.