| Subject | Re: [firebird-support] Problem with CONTAINING and COLLATE |
|---|---|
| Author | Mark Rotteveel |
| Post date | 2017-12-08T10:56:38Z |
On 2017-12-07 19:06, Dimitry Sibiryakov sd@...
[firebird-support] wrote:
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
[firebird-support] wrote:
> 07.12.2017 18:46, Gabor Boros mlnglsts@... [firebird-support]I don't agree with this. The string literal is in the connection
> 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.
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