FOLDEDSIMPLEMATCH

FOLDEDSIMPLEMATCH returns a FIXED BINARY(31) value that indicates whether two strings are identical when folded to lowercase according to the Unicode simple case folding rules. If two strings are identical, the return value is 0. Otherwise, the returned value is nonzero.

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 FOLDEDSIMPLEMATCH built-in function, all UTF-8 data items from all code blocks will be folded as necessary.

In simple case folding, the lengths of x and y must be equal. For example, Haus and HAUS would match, but Straße and STRASSE would not match.