Hi
>Is this the same for the other environments?
We have recently upgraded others to 10 and are in testing before we upgrade production. However we still some 9.6 dev
serverswhich are fine.
>What does:
>SHOW lc_collate;
en_US.UTF-8
>Are you doing the below through Navicat or psql?
Using Navicat for the test in all environments, but we have the same issue with app layer code connecting via perl
DBI.
Z