SQLite Forum

Show duplicate rows sorted
Login
Why not just:

```
  select name
    from records
group by name collate unicode
  having count(*) > 1
order by name collate unicode
;
```

I would seem to me that the "group by" needs a collation as well since there is the possibility that different "binary" representations may equate to "equal" unicode representations.  That is to say that there is more than one "binary" way to express the same "unicode" presentation.