db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mike Matrigali <mikem_...@sbcglobal.net>
Subject Re: comparisons between system and user table columns with TERRITORY_BASED collation
Date Mon, 25 Jun 2007 17:16:48 GMT
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?

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

Mime
View raw message