Hi!

On Sep 11, 2008, at 11:38 AM, Jim Starkey wrote:

Cast is a standard and useful feature for forcing conversions. I see no purpose for Convert with a single internal character set.

A lot of the "2" + 2 stuff we do automatically, so convert() is less useful (though I will full acknowledge that some of the auto conversion is too friendly).

Could somebody say something about the general philosophy for collations? How do they interact with comparisons?


The only thing that comes to mind is "A" == "a", aka case, also umlaut vs non-umlaut characters for other languages. So it is not only a question of sort, but in doing comparison to names.

The "SELECT BINARY a = A" stuff I find questionable. What does it even mean to sort a BLOB for instance?

Cheers,
        -Brian

--
_______________________________________________________
Brian "Krow" Aker, brian at tangent.org
Seattle, Washington
http://krow.net/                     <-- Me
http://tangent.org/                <-- Software
_______________________________________________________
You can't grep a dead tree.




_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to     : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help   : https://help.launchpad.net/ListHelp

Reply via email to