Feedback by UserVoice

Oleg Pchelkin

My feedback

  1. 37 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    5 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Oleg Pchelkin commented  · 

    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

    Oleg Pchelkin supported this idea  · 

Feedback and Knowledge Base