danshockley

not-equals character is wrongly "same" as equals character

Discussion created by danshockley on Feb 6, 2018
Latest reply on Feb 13, 2018 by danshockley

Product and version (e.g. FileMaker Pro 14.0.3): 16.0.3

OS and version: macOS Sierra 10.12.6

Hardware: MacBook Pro 2.9 GHz

 

Description:

 

When you do a simple string comparison in FileMaker using the equals operator ( = ), it says that the following two characters are the same:

= , ≠

In other words, the following calculation returns 1:

"≠" = "="

We all know that FileMaker's default comparison is case-insensitive, but I don't think the not-equals character should be treated as a different "case" of the equals character. Nor should it be treated as an "accented equals" (like "é" = "e" for simple comparisons).

 

How to replicate:

 

In any calculation, do this:

"≠" = "="

 

Workaround (if any):

 

Use Exact ( "≠" ; "=" ), which correctly returns 0.

Outcomes