0 Replies Latest reply on Jun 28, 2005 2:27 PM by 413431

    Publish data from database with swedish characterset

    413431
      Hi,
      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 ?
      Regards,
      Susanne