On Mon, Nov 30, 2009 at 06:37:11PM +0000, Simon Slavin scratched on the wall:
>
> On 30 Nov 2009, at 5:51pm, Nicolas Williams wrote:
>
> > Consider a column that contains a person's last name. Q: do proper
> > names have a language? A: No, since people can be from all over and
> > even within a single country may have last names of various radically
> > different origins.
>
> But what is the purpose of collating a column ? Why, to allow
> it to be indexed, of course.
That's ONE reason. You can give a column a specific collation
without having to index it. It provides the "natural" order for an
ORDER BY. You can also give ORDER BY an explicit collation to use
for that specific query.
-j
--
Jay A. Kreibich < J A Y @ K R E I B I.C H >
"Our opponent is an alien starship packed with atomic bombs. We have
a protractor." "I'll go home and see if I can scrounge up a ruler
and a piece of string." --from Anathem by Neal Stephenson
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
