开发者

SQL Server Import Character Encoding Excel

So I am doing a SQL Import via Sql Server Import and Export Wizard with an Excel spread sheet and the following happens:

Veubroncé comes in 开发者_Python百科as Veubroncã‰

Any way to avoid this?


This happens when UTF-8 encoded text is interpreted as ANSI encoded text. Are you sure you're not importing a CSV text file rather than Excel? Open the CSV file in Notepad and change the encoding to "UTF-8 with signature".

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜