On Thu, Sep 5, 2013 at 9:31 AM, Igor Tandetnik <i...@tandetnik.org> wrote:
> On 9/5/2013 7:31 AM, Richard Hipp wrote: > >> There seems to be some misinformation circulating in this thread. Please >> let me try to clear up a few points. >> > > While we are at it, an interesting question was raised upthread. What > happens here: > > create table t1(x text collate c1); > create table t2(x text collate c2); > > select x from t1 > union > select x from t2 > order by x; > > Which collation is used by UNION to deduplicate? Which collation is used > by ORDER BY to sort? > The left-most. http://www.sqlite.org/src/artifact/8b148eb851f?ln=1582-1602 -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
