OK. I am also wondering about the 2 character sets that Derby 10.3 would have. All the user schemas as per the wiki page would have USER character set and the system schemas will have SQL_IDENTIFIER character associated with them. I am wondering if we leave these at conceptual level and just have the collation type correctly set on the SchemaDescriptor? ie no code corresponding to character set in SchemaDescriptor?
Mamta On 4/4/07, Daniel John Debrunner <[EMAIL PROTECTED]> wrote:
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. > > >
