Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

SQLServer 中文乱码及查询异常 | 山雨欲来兮丶 #57

Open
Sdreamery opened this issue Aug 21, 2024 · 0 comments
Open

SQLServer 中文乱码及查询异常 | 山雨欲来兮丶 #57

Sdreamery opened this issue Aug 21, 2024 · 0 comments
Labels
fd3d4fb10b5d57c62bda064d68c38a03 Gitalk

Comments

@Sdreamery
Copy link
Owner

https://www.seanxia.cn/%E6%97%A5%E5%B8%B8%E9%97%AE%E9%A2%98/49955695.html

记录一次工作中SQLServer查询异常的经历。 由于直连供应商那边要求使用sqlserver接收数据，故我们又在207安装了SQLServer数据库，我这边正常建表，然后导入数据，刚开始客户类型，厂家等字段使用常用字符串类型varchar，但是导入发现除数字和字母外，中文部分乱码，后来网上了解到，中文需用到Unicode字符集，故如果含有中文需要用nvarchar，以下是网上查找到varchar
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
fd3d4fb10b5d57c62bda064d68c38a03 Gitalk
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@Sdreamery