How to change the encoding used for CSV EXPORT format from Unicode to UTF-8?
Exporting to CSV uses a default encoding of Unicode (UTF-16le). Can this be changed to UTF-8?
Resolving the problem
- Open the IBM Cognos Administration page
- Select the Configuration tab and select Dispatchers and Services
- Click on Set Properties
- Select the Settings tab
- To the right of Advanced Settings, select Edit...
- Enter parameter "RSVP.CSV.ENCODING" and value "utf-8"
- 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.
More support for:
Cognos Business Intelligence
Software version: 10.1, 10.1.1, 10.2, 10.2.1, 10.2.2
Operating system(s): AIX, HP-UX, Linux, Solaris, Windows, z/OS
Reference #: 1340862
Modified date: 08 March 2010