Mamta Satoor wrote:
Yes, I thought of going that track, but that would involve saving the
collation type in SYSCHEMAS and thus some hard upgrade code. In soft
upgrade, we can't upgrade SYSCHEMAS, so some mechanism to have it
default to UCS_BASIC.
No, no need to save anything in SYSSCHEMAs. The data dictionary could
set the schema's default collation default type when loading.
SchemaDescriptor has a isSystemSchema() method so it's clear which are
system schemas and which are not.
Dan.
The collation you are looking for is a property of the schema, see this
from your 1478 wiki page:
> 2)<column definition> (of character string type) SQL spec Section
11.1 <schema definition>, General Rule 3 specifies that the
character set associated with schema is used as the default
character set for all <column definitions>.
Thus, since it's a property of the schema, the most logical place for
this is as a method on SchemaDescriptor,
e.g.
public int getCollationType();
Dan.
