AnsweredAssumed Answered

Unicode characters 55296-57348 mishandled by fields and Evaluate(Quote())

Question asked by jbante on Nov 16, 2012
Latest reply on May 6, 2013 by codecruncher


Unicode characters 55296-57348 mishandled by fields and Evaluate(Quote())


FileMaker Pro


FileMaker Pro Advanced 12.0v3

Operating system version

Mac OS 10.8.2

Description of the issue

For unicode characters Char ( 55296 ) through Char ( 57343 ), storing that character by itself in a text field changes the character to Char ( 53 ), according to comparing Code ( textField ) to the original Char ( $code ) calculation used to set the field.

For the same range of characters, Evaluate ( Quote ( Char ( $code ) ) ) converts characters 55296-57347 to Char ( 90 ), and character 57348 to Char ( 32 ).

Steps to reproduce the problem

I created a demo file to narrow-down the source of what was causing me trouble, and I can provide that file on request. (I wish I could include it in the issue report form, but I can't.)

For the first example, set a text field with the calculation "Char ( $code )" where the variable $code contains an integer between 55296 and 57343. After the field is set, compare Code ( textField ) to the original $code.

For the second example, try the calculation "Code ( Evaluate ( Quote ( Char ( $code ) ) ) ) = $code" for any value of the $code variable between 55296 and 57348.

Expected result

The final character should match the original character after going through either process.

Actual result

The final character is a different character than the original character. Large ranges of input characters often get mapped to the same output character.

Exact text of any error message(s) that appear