Peter Eisentraut <peter.eisentraut@xxxxxxxxxxxxxxxx> writes: > There are also cases where on one system the locale is spelled > xx_YY.UTF8 and on another xx_YY.UTF-8. If we start adjusting for case, > should we adjust for this as well? What other cases are there? > So this would need a bit more research. Yeah. I would tend to define it as "if the locale names both end in dot followed by a recognizable encoding name, then (a) make sure that the encoding values are the same, then (b) strip off the dot and encoding before comparing the rest". We already have code to look up encoding names, and it handles all these variants. So this doesn't seem like it should take much new code, though maybe some refactoring would be needed to make the lookup code available where this check is happening. I'm not personally very excited about this, but if someone wanted to prepare a patch... regards, tom lane
