On 2017-12-07 19:06, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: > 07.12.2017 18:46, Gabor Boros mlngl...@bgss.hu [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 > PXW_HUNDC.
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. Mark