On 2017-12-08 12:01, Dimitry Sibiryakov [email protected] [firebird-support] wrote: > 08.12.2017 11:56, Mark Rotteveel [email protected] > [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 ;) Mark
