bcp和unicode [英] bcp and unicode
问题描述
我有一个大型CSV文件（250K行），我正在使用bcp运行在AWS RDS Sql Server Express v12.0上的表中EC2 Linux实例。 CSV是utf-8。在玩了很多设置之后，我将错误最小化到250K中的150个。然而，
似乎绊倒了商标的符号 - tm带有圆圈上标。为了使上传工作到目前为止，我不得不使用带有空collation字段的格式文件，并在AWS端设置一个staging表，列为nvarchar。除了少数具有商标符号的行外，它的工作效果为
。非常感谢任何建议。
I have a large CSV file (250K rows) that I am uploading to a table on AWS RDS Sql Server Express v12.0 using bcp running on an EC2 Linux instance. The CSV is utf-8. After playing with lots of settings, I have minimized errors to about 150 out of 250K. However, it seems to trip over the symbol for trade mark - tm with a circle superscript. To get the upload to work so far I have had to use a format file with an empty collation field and set up a staging table on the AWS end with columns that are nvarchar. It works well except for the few rows that have the trade mark symbol. Would appreciate any suggestions.
谢谢！
推荐答案
Hi msdnps，
Hi msdnps,
谢谢你的支持发布。
根据您的描述，
我认为一种可能性 是该问题可能与 AWS RDS Sql Server而非Microsoft SQL Server有关。请在相应的论坛中发布您的问题，您将获得更专业的
帮助。 论坛：亚马逊关系型数据库服务
Per your description, I think one possibility is that the issue may be related to AWS RDS Sql Server instead of Microsoft SQL Server. Please post your issue in the corresponding forum, and you will get more professional help. Forum: Amazon Relational Database Service
如果您在相应的论坛中发布了您的问题，请将有用的回复或您自己的回复标记为答案。 通过这样做， 它将使所有社区成员受益，因为他们有类似的问题。 您的贡献得到了高度赞赏。
If you have post your issue in the corresponding forum, please kindly mark the helpful replies or your own reply as answers. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.
希望它
可以帮助你。
Hope it can help you.
最好的问候，
Rachel
这篇关于bcp和unicode的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
