My feedback

1. Fix the comparison of strings with Unicode Latin Extended-D characters

   37 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   5 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
   An error occurred while saving the comment
   Oleg Pchelkin commented  ·  October 23, 2019  ·  Edit…  ·  Delete…

   Also affected: Javanese script. Run four queries.
   SELECT 'ꦫ' AS SIGN INTO JAVANESE ;
   INSERT INTO JAVANESE ( SIGN ) SELECT 'ꦗ' AS SIGN;
   INSERT INTO JAVANESE ( SIGN ) SELECT 'ꦣ' AS SIGN;
   SELECT SIGN FROM JAVANESE WHERE SIGN = 'ꦫ'

   The last query returns three records instead of one, because for microsoft access all javanese signs are the same. (SELECT 'ꦫ' = 'ꦣ' as COMPARISON_RESULT;
   returns true )
   You can also compare Javanese signs with emoji:
   (SELECT 'ꦧ' = '😦' as COMPARISON_RESULT;
   returns true ).
   Note that VBA is not affected, only the database engine

   Save Submitting...
   Oleg Pchelkin supported this idea  ·  October 23, 2019