String key = DatabaseUtils.getHexCollationKey("Frederic Hjonneva"); Assert.assertEquals(1, longForQuery(mDatabase, "SELECT count(*) from tokens where token GLOB '" + key + "*'", null)); Assert.assertEquals(0, longForQuery(mDatabase, "SELECT token_index from tokens where token GLOB '" + key + "*'", null)); key = DatabaseUtils.getHexCollationKey("Hjonneva"); Assert.assertEquals(1, longForQuery(mDatabase, "SELECT count(*) from tokens where token GLOB '" + key + "*'", null)); key = DatabaseUtils.getHexCollationKey("some string ok"); Assert.assertEquals(1, longForQuery(mDatabase, "SELECT count(*) from tokens where token GLOB '" + key + "*'", null)); Assert.assertEquals("foo", stringForQuery(mDatabase, "SELECT tag from tokens where token GLOB '" + key + "*'", null)); key = DatabaseUtils.getHexCollationKey("string"); Assert.assertEquals(1, longForQuery(mDatabase, "SELECT count(*) from tokens where token GLOB '" + key + "*'", null)); Assert.assertEquals("foo", stringForQuery(mDatabase, "SELECT tag from tokens where token GLOB '" + key + "*'", null)); key = DatabaseUtils.getHexCollationKey("ok"); Assert.assertEquals(1, longForQuery(mDatabase, "SELECT count(*) from tokens where token GLOB '" + key + "*'", null)); key = DatabaseUtils.getHexCollationKey("second field"); Assert.assertEquals(1, longForQuery(mDatabase, "SELECT count(*) from tokens where token GLOB '" + key + "*'", null));