Martijn van Oosterhout wrote:
I think that if SQL COLLATE gets in we'll get this almost for free. Collation and charset are both properties of strings. Once you've got a mechanism to know the collation of a string, you just attach the charset to the same place. The only difference is that changing charsets requires recoding, wheres changing collation does not.
Not quite. Collation is a property of the operation that you're doing. For example, if you're doing a sort, you might do it in different collation depending on the user that's doing it, or it might even be chosen by the user case-by-case. Of course, usually you have a default set per-database, per-table or per-column, but it's not a property of the actual value of a field. I think that the phrase "collation of a string" doesn't make sense.
-- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend