Re: [firebird-support] Problem with CONTAINING and COLLATE - UTF8

2017-12-20 Thread Gabor Boros mlngl...@bgss.hu [firebird-support]
2017. 12. 19. 21:13 keltezéssel, setysvar setys...@gmail.com [firebird-support] írta: > Why would you want collate AFTER containing? I must admit I haven't > tried your queries in Fb 3.0 (I'm still on 2.5), but I'd say the > sensible way to specify what you want, would be > > SELECT * FROM

Re: [firebird-support] Problem with CONTAINING and COLLATE - UTF8

2017-12-19 Thread setysvar setys...@gmail.com [firebird-support]
>After the original "Problem with CONTAINING and COLLATE" thread I switched to UTF8 but not happy with it. >The optional COLLATE after CONTAINING have no effect, the database default COLLATION used. See the below >examples. Tried with 3.0.3.32854 snapshot and Linux 64bit (Ubuntu 14.04.1).

[firebird-support] Problem with CONTAINING and COLLATE - UTF8

2017-12-19 Thread Gabor Boros mlngl...@bgss.hu [firebird-support]
Hi All, After the original "Problem with CONTAINING and COLLATE" thread I switched to UTF8 but not happy with it. The optional COLLATE after CONTAINING have no effect, the database default COLLATION used. See the below examples. Tried with 3.0.3.32854 snapshot and Linux 64bit (Ubuntu