| Subject | Re: [firebird-support] Problem with CONTAINING and COLLATE - UTF8 |
|---|---|
| Author | Gabor Boros |
| Post date | 2017-12-20T08:02:21Z |
2017. 12. 19. 21:13 keltezéssel, setysvar setysvar@...
[firebird-support] írta:
Gabor
[firebird-support] írta:
> Why would you want collate AFTER containing? I must admit I haven'tThank you very much Set! With the correct syntax works as expected.
> 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 TABLE1 WHERE NAME COLLATE UNICODE_CI_AI CONTAINING 'o';
Gabor