The SYSCOLLATION compatibility view contains the collation sequence information for the database. It is obtainable via built-in functions and is not kept in the catalog. Following is definition for this view:
ALTER VIEW "SYS"."SYSCOLLATION" as select 1 as collation_id, DB_PROPERTY('Collation') as collation_label, DB_EXTENDED_PROPERTY('Collation','Description') as collation_name, cast(DB_EXTENDED_PROPERTY('Collation','LegacyData') as binary(1280)) as collation_order;
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|