SYSCOLLATIONMAPPINGS 兼容性视图只有一行,其中包含数据库归类映射。它可通过内置函数来获得且不是保存在目录中。以下是该视图的定义:
ALTER VIEW "SYS"."SYSCOLLATIONMAPPINGS" as select DB_PROPERTY('Collation') as collation_label, DB_EXTENDED_PROPERTY('Collation','Description') as collation_name, DB_PROPERTY('Charset') as cs_label, DB_EXTENDED_PROPERTY('Collation','ASESensitiveSortOrder') as so_case_label, DB_EXTENDED_PROPERTY('Collation','ASEInsensitiveSortOrder') as so_caseless_label, DB_EXTENDED_PROPERTY('Charset','java') as jdk_label; |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |