要想创建对于所有字符串比较不区分大小写的数据库,需要使用排序规则U CA500R1,见清单4。
To create a database that is case-insensitive for all string comparisons, it is necessary to use the collation UCA500R1 as shown in Listing 4.
换句话说,在不区分大小写的数据库中,字符串比较的开销可能会略微增加。
In other words, string comparisons may be slightly more expensive in a case-insensitive database.
例如,在丹麦语中,对两个字母组成的字母对“AA”和“AA”进行不区分大小写的比较时,它们被认为是不相等的。
For example, in the Danish language, a case-insensitive comparison of the two-letter pairs "AA" and "AA" is not considered equal.
应用推荐