Subject Re: [firebird-support] Problem with CONTAINING and COLLATE
Author Mark Rotteveel
On 2017-12-08 12:01, Dimitry Sibiryakov sd@...
[firebird-support] wrote:
> 08.12.2017 11:56, Mark Rotteveel mark@...
> [firebird-support] wrote:
>> I don't agree with this. The string literal is in the connection
>> character set, but the value should be converted to the target
>> character
>> set (of the column) for the comparison
> No. Imagine connection charset to be UTF-8 and some characters in
> query that not exist
> in column charset. Should this situation throw "Cannot transliterate"
> error or return no
> results?

It should return no results. If it can't transliterate, it means that
the character definitely does not exist in the target column, so the
comparison is false. It should issue a warning in my opinion (and I
believe the SQL standard agrees on that, but I don't have time to back
that up ;)