github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/sql/logictest/testdata/logic_test/collatedstring_normalization (about)

     1  statement ok
     2  CREATE TABLE t (
     3    a STRING COLLATE fr PRIMARY KEY
     4  )
     5  
     6  # Insert Amélie in NFD form.
     7  statement ok
     8  INSERT INTO t VALUES (b'Ame\xcc\x81lie' COLLATE fr)
     9  
    10  # Retrieve Amélie in NFC form.
    11  query T
    12  SELECT a FROM t WHERE a = (b'Am\xc3\xa9lie' COLLATE fr)
    13  ----
    14  Amélie
    15  
    16  statement ok
    17  DELETE FROM t
    18  
    19  # Insert Amélie in NFC form.
    20  statement ok
    21  INSERT INTO t VALUES (b'Am\xc3\xa9lie' COLLATE fr)
    22  
    23  # Retrieve Amélie in NFD form.
    24  query T
    25  SELECT a FROM t WHERE a = (b'Ame\xcc\x81lie' COLLATE fr)
    26  ----
    27  Amélie