FOLDEDFULLMATCH
FOLDEDFULLMATCH returns a FIXED BINARY(31) value that indicates whether two strings are identical when folded to lowercase according to the Unicode full case folding rules. If two strings are identical, the return value is 0. Otherwise, the returned value is non-zero.
- x
- Expression. x must have computational type and is converted to UCHAR type if necessary.
- y
- Expression. y must have computational type and is converted to UCHAR type if necessary.
When you use the FOLDEDFULLMATCH built-in function, all UTF-8 data items from all code blocks will be folded as necessary.
In full case folding, the lengths of x and y do
not need to be the same. For example, not only Haus
and HAUS
would
match, but Straße
and STRASSE
would
also match.