Entrypoint stripstringhold not compatible with UTF-8 - use U_STRIPSTRINGHOLD
Entrypoint u_stripstringhold compatible with UTF-8
Input CSTRING(32760) String 1 CSTRING(254) String 2 as a list of all characters which are not to delete Output CSTRING(32760) String stripped from all characters which are not content of parameter 2
The sequence of the indications in the string 2 does not matter. Counterpart to F_STRIPSTRING Note: In a SQL F_HOLDSTRING and F_STRIPSTRINGHOLD may not use at the same time. TestSQL SELECT 'ieiteietet' AS ISCORRECT, F_HOLDSTRING('Dies ist ein Test Text', 'iet') FROM RDB$DATABASE; SELECT 'ieiteietet' AS ISCORRECT, F_HOLDSTRING('Dies ist ein Test Text', 'tei') FROM RDB$DATABASE; SELECT 'ieiteietet' AS ISCORRECT, F_HOLDSTRING('Dies ist ein Test Text', 'iet') FROM RDB$DATABASE; SELECT 'ieiteietet' AS ISCORRECT, F_HOLDSTRING('Dies ist ein Test Text', 'tei') FROM RDB$DATABASE; SELECT NULL AS ISCORRECT, F_STRIPSTRINGHOLD(NULL, NULL) FROM RDB$DATABASE;