开发者

SQL Server Import Character Encoding Excel

开发者 https://www.devze.com 2023-03-12 09:36 出处:网络
So I am doing a SQL Import via Sql Server Import and Export Wizard with an Excel spread sheet and the following happens:

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

精彩评论

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