db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Daniel John Debrunner <...@apache.org>
Subject Re: DERBY-1478 : Making the correct collation type available in CreateTableNode for character string type columns
Date Wed, 04 Apr 2007 20:37:04 GMT
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.



>     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.

View raw message