We have trouble with publishing data (including decimal numbers and dates) from a database with a swedish character set. Adapters and hub database are running in american character set.
I suppose this is handled by setting NLS parameters in adapter.ini and/or the start script, but I can't make it work. The adapter raise 'numeric value error' and 'date format error'.
(As a test I changed NLS to american (by 'alter session...') before calling the publishing procedure, and then i works, but in our case this is is not a possible solution since the events are initiated by triggers.)
Does anyone know how to solve this ?