Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Reference » Views » Compatibility views

Compatibility views Next Page

SYSCOLLATION compatibility view (deprecated)


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
See also