Entrypoint stringcount compatible with UTF-8
Input CSTRING(32760) String1 CSTRING(254) String2 Output INTEGER Amount of String 2 in String 1
Entrypoint r_stringcount compatible with UTF-8
Input CSTRING(254) String 1 CSTRING(32760) String 2 Output INTEGER Amount of String 1 in String 2
TestSQL SELECT 2 AS ISCORRECT, F_STRINGCOUNT( 'ABC 123 45678 9123', '123'), F_RSTRINGCOUNT('123', 'ABC 123 45678 9123') FROM RDB$DATABASE; SELECT 0 AS ISCORRECT, F_STRINGCOUNT( 'ABC 123 45678 9123', 'EFG'), F_RSTRINGCOUNT('EFG', 'ABC 123 45678 9123') FROM RDB$DATABASE; SELECT NULL AS ISCORRECT, F_RSTRINGCOUNT(NULL, NULL) FROM RDB$DATABASE;