>I am not following above. >What is running version 10? Production is 9.6, others are 10 (as we are testing). Prod has always been fine, its been running for 2 years without a hitch. This issue has only occurred recently >Did you restore a dump from a version 10 onto a >version 9.6 machine? No - as I said, I don’t believe it’s a version issue as its been fine for 2 years. > >> What does: >> SHOW lc_collate; > > en_US.UTF-8 >The above is the same for all the servers? The upgraded 10 servers are en_GB.UTF_8. The current prod 9.6 is as above Z
