Mike Matrigali <[EMAIL PROTECTED]> 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
