SQLite 的 BINARY, NOCASE 和 RTRIM 内置排序方式不支持Unicode编码，导致中文无法按拼音排序。在Windows环境下，需要自定义排序序列实现Unicode排序。Android已提供'UNICODE'排序。本文介绍在WPF+实体关系模型下，如何实现忽略大小写并按Unicode排序的方法。"
133451792,19671763,编程中的Prtscr键：捕捉屏幕截图示例,"['编程语言', 'Python', '开发工具']
Sqlite数据库内建的排序序列(
collating sequence
)有三种： BINARY、NOCASE和RTRIM。
以下是Sqlite.Org对这三种排序方式的描述（原文地址：http://www.sqlite.org/datatype3.html）：
以下是Sqlite.Org对这三种排序方式的描述（原文地址：http://www.sqlite.org/datatype3.html）：
6.0 Collating Sequences
When SQLite compares two strings, it uses a collating sequence or collating function (two words for the same thing) to determine which string is greater or if the two strings are equal. SQLite has three built-in collating functions: BINARY, NOCASE, and RTRIM.
BINARY - Compares string data using memcmp(), regardless of text encoding.
NOCASE - The same as binary, except the 26 upper case characters of ASCII are folded to their lower case equivalents before the comparison is performed. Note that only ASCII characters are case folded. SQLite does not attempt to do full UTF case folding due to the size of the tables required.
RTRIM - The same as binary, except
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
