Re: Mixed Locales and Upgrading

On 2020-03-30 17:30:32 -0400, Tom Lane wrote:
> Don Seiler <don(at)seiler(dot)us> writes:
> > Actually, would I need to re-index on text columns that we know contain
> > UUID strings? UUID characters seem to be pretty basic alphanumeric ASCII
> > characters.
>
> I think you're all right with respect to those, since they're the
> same under any encoding. It's columns containing non-ASCII characters
> that you'd want to worry about reindexing.

I'm not so sure whether all locales agree on whether to sort digits
before or after letters. However there are only two possibilities and
that's easy to check.

hp

--
_ | Peter J. Holzer | Story must make more sense than reality.
|_|_) | |
| | | hjp(at)hjp(dot)at | -- Charles Stross, "Creative writing
__/ | http://www.hjp.at/ | challenge!"