Script the column collation only if it is different from the database collation check box.
“仅当列排序规则与数据库排序规则不同时才编写列排序规则脚本”复选框。
Using the ‘wrong’ database collation for the IBM Cognos Controller application repository database will cause problems in the future.
对IBMCognosController应用程序存储库数据库使用 “错误” 的数据库校对(collation)会在将来导致问题。
If you clear this check box, database columns will always have their collation scripted, even if it matches the database collation.
如果清除此复选框,那么,将总是为数据库列编写排序规则脚本,即使它与数据库排序规则匹配也是如此。
If you select this check box, the build script will set the collation for only those columns whose collation does not match the database collation.
如果选中此复选框,则生成脚本将只为那些排序规则与数据库排序规则不匹配的列设置排序规则。
You can limit when column collations are explicitly specified to only those cases in which the column collation does not match the database collation.
可以限制只有当列排序规则与数据库排序规则不匹配时才显式指定列排序规则。
You cannot transfer a database from one SQL server (to a different SQL server) if the two servers have different server default collation Settings.
如果两个SQL服务器拥有不同的服务器默认校对设置,那么您不能将一个数据库从一个SQL服务器传输到另一个SQL服务器。
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.
要想创建对于所有字符串比较不区分大小写的数据库,需要使用排序规则UCA500R1,见清单4。
This is because the IBM Cognos Controller database must match the collation setting of the TEMPDB database, so that it can transfer information correctly.
这是因为IBMCognosController数据库必须匹配TEMPDB数据库的校对设置,以便它能正确传输信息。
Using a customized collation for the database may have an impact on the query performance since the number of possible string matches increases when you choose a looser UCA setting.
在数据库中使用定制的排序规则可能影响查询性能,因为在选择更宽松的 UCA 设置时,匹配的字符串数量可能会增加。
The database character set and collation are used as default values if the table character set and collation are not specified in CREATE table statements.
如果在CREATETABLE语句中没有指定表字符集和校对规则,则使用数据库字符集和校对规则作为默认值。
This makes collation similar to encoding, which was always configurable per database.
这样,此类配置就可以与一直作为每数据库单独配置的编码一致了。
You probably want to use the collation of the target database because the staging or production environment is already set up.
您可能要使用目标资料库的定序,因为执行或实际执行环境已设定完成。
Now I summarize some commands used to see what are the character set and collation of our database and how to change them as needed.
现在,我总结了一些命令用于查看我们使用的数据的字符集以及根据需要如何改变字符集。
Now we may want to check some variables about character set and collation for our database client and server, for example, connection character set.
接下来,我们想检查数据端和服务的一些有关于字符集的变量,例如:连接字符集。
Now we may want to check some variables about character set and collation for our database client and server, for example, connection character set.
接下来,我们想检查数据端和服务的一些有关于字符集的变量,例如:连接字符集。
应用推荐