db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Knut Anders Hatlen <Knut.Hat...@Sun.COM>
Subject Re: comparisons between system and user table columns with TERRITORY_BASED collation
Date Tue, 26 Jun 2007 14:05:54 GMT
Mike Matrigali <mikem_app@sbcglobal.net> writes:

> This sounds like an easy solution to this issue, but will change the
> error message for all comparison mismatches that are not territory
> related.  Does that sound ok?

Sounds OK to me. This doesn't look too bad:

ERROR 42818: Comparisons between 'VARCHAR(UCS_BASIC)' and 'INTEGER' are
not supported

> Bryan Pendleton wrote:
>>> ERROR 42818: Comparisons between 'VARCHAR' and 'VARCHAR' are not
>>> supported.
>>
>> Yes, I think that this error message would be quite confusing.
>>
>> Can we make it say something like:
>>
>> ERROR 42818: Comparisons between 'VARCHAR(en_US)' and
>> VARCHAR(UCS_BASIC)' are not supported.
>>
>> That is, sort of pack the collation information into the datatype
>> name somehow?
>>
>> thanks,
>>
>> bryan
>>
>>
>>

-- 
Knut Anders

Mime
View raw message