We are running SAP, which sets the db_locale to de_de (I guess because SAP
is German). The interesting this is that the sysmaster and sysutils
databases are set to 'en_US.819' per the sysdbslocale table, but the SAP
databases have a setting of 'C'.
I have another database (on another machine) with the db_locale set to
en_US.819. I am trying to create a synonym from the SAP database to the
'normal' database, yet I keep getting db_locale errors.
I have tried setting the DB_LOCALE and CLIENT_LOCALE environment variables,
but without success. If I set either of these variables to anything
(en_US.819 or C), I can't connect to the SAP database.
Is it possible to change the db_locale setting for a database, or would that
corrupt the data?
Or, does anyone have any other ideas?
Thanks in advance.