Hi,

Dne 05. 11. 21 v 12:54 Alex Peshkoff via Firebird-devel napsal(a):

Pavel - how this SHOULD be in firebird from big clients POV?
STARTING WITH "HROC" should return only HROCENI or HROCH too?

They prefer that "C" should NOT match "CH" (which is also how Oracle and SQLServer do it).

Fact is, that if the pattern ends with "C", it's ment as "C" and not "CH". If user wants to look for "CH", it's defined explicitly as such, i.e. trailing "C" is never "unfinished CH".

regards
Pavel





Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to