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?
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
