Skip to content
This repository has been archived by the owner on Jun 16, 2021. It is now read-only.

数据库编码影响结果排序顺序 #88

Closed
dengsh12 opened this issue Jun 4, 2021 · 7 comments
Closed

数据库编码影响结果排序顺序 #88

dengsh12 opened this issue Jun 4, 2021 · 7 comments
Labels
Answered Answered questions

Comments

@dengsh12
Copy link

dengsh12 commented Jun 4, 2021

在testSearchCourses1的第133个case中，expected第0项courseid为CS102A,fullName为计算机程序设计基础A[中英双语1班-实验5班],第5项courid为CS102A，fullName为计算机程序设计基础A[英文班-实验3班]，但是按照文档要求，应该以courseid为第一关键字，fullName为第二关键字排序，这两项courseid相同，但第五项的fullName字典序小于第0项，按文档要求应是第五项排在前面
，此处数据是否有误？
@NewbieOrange
Copy link
Owner

图片

不是"中英" < "英文" 吗？

@NewbieOrange NewbieOrange added the Invalid This doesn't seem right label Jun 4, 2021
@dengsh12
Copy link
Author

dengsh12 commented Jun 4, 2021

图片

不是"中英" < "英文" 吗？

image
wo'zhe'l可是我这里英文小于中英诶 是啥原因啊

@NewbieOrange
Copy link
Owner

图片

@dengsh12
Copy link
Author

dengsh12 commented Jun 4, 2021

解决了 是编码的问题，感谢

@NewbieOrange
Copy link
Owner

解决了 是编码的问题，感谢

是需要用UTF-8吗？

@dengsh12
Copy link
Author

dengsh12 commented Jun 4, 2021

解决了 是编码的问题，感谢

是需要用UTF-8吗？
是的

@NewbieOrange NewbieOrange changed the title 有关searchCourse数据疑问 数据库编码影响结果排序顺序 Jun 4, 2021
@NewbieOrange NewbieOrange added the Answered Answered questions label Jun 4, 2021
@NewbieOrange NewbieOrange pinned this issue Jun 4, 2021
@NewbieOrange NewbieOrange removed the Invalid This doesn't seem right label Jun 4, 2021
@KingOfXi KingOfXi mentioned this issue Jun 5, 2021
Closed
@NewbieOrange
Copy link
Owner

创建符合需求的数据库的方法：

图片

直接执行即可（红色提示没关系）。

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Assignees
No one assigned
Labels
Answered Answered questions
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@NewbieOrange @dengsh12