Subject Re: [firebird-support] Problem with CONTAINING and COLLATE
Author Mark Rotteveel
On 2017-12-07 19:06, Dimitry Sibiryakov sd@...
[firebird-support] wrote:
> 07.12.2017 18:46, Gabor Boros mlnglsts@... [firebird-support]
> wrote:
>> Why does the connection charset count?
> Because you are sending queries in connection charset. And string
> literals in them are
> in connection charset. Because of that your 'x' cannot have COLLATE

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, and that target character set
does know PXW_HUNDC.

Right now, it looks like instead Firebird only tries to apply the target
collation, and not the target character set.