Martijn van Oosterhout <kleptog@svana.org> writes: > Yet hashing is also a property of the collation, not the type. The same > string in different locales would hash differently.
I think this is a mistake -- the same mistake that got us into trouble with Turkish. Hashing depends on the concept of equality which is integral to the type. Two things are either the same or they aren't, and that can't change based on context. Specifically in the case of strings, two strings should only be considered "equal" if they consist of the exact same series of characters. (That is, they could be encoded differently but they have to encode the same actual characters.) That they happen to sort equally compared to all other strings doesn't mean that they're equal. -- greg ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings