Db2 Create database时COLLATE USING的解释
摘自IBM官网,个人渣翻译,欢迎指正
个人理解下来collating sequence是用于数据库在比较数据大小的基准表,简单点的例子就是用于判断 正序排序时 字符A与字符B 谁在前谁在后的一个用于比较的基准表。
The database manager compares character data using a collating sequence. This is an ordering for a set of characters that determines whether a particular character sorts higher, lower, or the same as another.
数据库实例使用collating sequence比较字符数据,这是一序列的字符用于比较单独字符的大、小、相等。
The Unicode Collation Algorithm (UCA) uses weight tables to determine the collating sequence.
Unicode排序规则算法(UCA)使用权重表确定排序顺序。
NoteCharacter string data defined with the FOR BIT DATA attribute, and BLOB data, is sorted using the binary sort sequence.
Note:使用FOR BIT DATA 参数的字符串数据、BLOB数据 使用binary sort sequence进行排序。
For example, a collating sequence can be used to indicate that lowercase and uppercase versions of a particular character are to be sorted equally.
举个例子,collating sequence可以用于标志 特定字符的大写、小写 进行完整的排序
The database manager allows databases to be created with custom collating sequences. The following sections help you determine and implement a particular collating sequence for a database.
数据库实例支持数据库在创建时选择自定义的collating sequences,下面的章节讲