| Subject | Re: [firebird-support] Problem with CONTAINING and COLLATE |
|---|---|
| Author | Mark Rotteveel |
| Post date | 2017-12-08T11:07:43Z |
On 2017-12-08 12:01, Dimitry Sibiryakov sd@...
[firebird-support] wrote:
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
[firebird-support] wrote:
> 08.12.2017 11:56, Mark Rotteveel mark@...It should return no results. If it can't transliterate, it means that
> [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?
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