IBM Support

How to change the encoding used for CSV EXPORT format from Unicode to UTF-8?

Troubleshooting


Problem

Exporting to CSV uses a default encoding of Unicode (UTF-16le). Can this be changed to UTF-8?

Resolving The Problem

  1. Open the IBM Cognos Administration page
  2. Select the Configuration tab and select Dispatchers and Services
  3. Click on Set Properties
  4. Select the Settings tab
  5. To the right of Advanced Settings, select Edit...
  6. Enter parameter "RSVP.CSV.ENCODING" and value "utf-8"
  7. Click OK

After the 60 seconds required for your changes to take effect, your changes are reflected when reports are generated in CSV format.

NOTE: if "Override the settings acquired from the parent entry" is checked in Step 5 on the individual service (ie. ReportService), the setting will not be enabled and will have to be manually entered on the service. This setting will override any properties inherited from this and other parent settings.

[{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Cognos Connection","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"},{"code":"PF035","label":"z\/OS"}],"Version":"10.1;10.1.1;10.2;10.2.1;10.2.2","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 June 2018

UID

swg21340862