Tom Lane wrote:
>
> See pg_controldata (a standard program in 7.3, contrib in the release or
> two before).
Thanks!
I have found the following differences between the pg_controldata output
from two postgres installation I had tought were identical:
DB1:
LC_COLLATE: C
LC_CTYPE: C
DB2:
LC_COLLATE: en_US.UTF-8
LC_CTYPE: en_US.UTF-8
Both databases contain EUC_JP data and DB2 does not seem to be able to
do EUC_JP text comparisons correctly whereas DB1 is. Am I right in
assuming this is because of the differences in the values of these two
variables?
If this is the cause of the problem how can I change the values of these
variables for DB2? I tried to set them in postgres.conf but that gave an
error:
FATAL: 'LC_COLLATE' is not a valid option nameFATAL: 'LC_COLLATE' is
not a valid option name
Thanks,
Jean-Christian Imbeault