You can modify properties for the comma separated values (CSV) output format. For example, you can specify encoding and field delimiter characters to suit your environment.
The CSV properties are system-wide settings and cannot be specified for specific reports.
Note: Always set the CSV output format at the server administration level. Do not override CSV output format settings at lower levels.
Start Cognos Connection.
In the upper-right corner, click Launch, Cognos Administration.
On the Status tab, click System.
From the System drop-down menu, click Set properties.
Click the Settings tab.
Next to Environment, Advanced Settings, click Edit.
Enter parameters and values from CSV Properties and Values, as required.
Click OK.
After the 30 seconds required for your changes to take effect, your changes are reflected when reports are generated in CSV format.
The following table describes the CSV properties that you can modify. If a property is not specified or its value is empty, the default setting is used.
The following table shows encoding values that are supported and tested by Cognos.
Character set | Supported encoding value |
UTF-8 | utf-8 |
Western European (ISO 8859-1) | iso-8859-1 |
Western European (ISO 8859-15) | iso-8859-15 |
Western European (Windows-1252) | windows-1252 |
Central and Eastern European(ISO 8859-2) | iso-8859-2 |
Central and Eastern European (Windows-1250) | windows-1250 |
Cyrillic (ISO 8859-5) | iso-8859-5 |
Cyrillic (Windows-1251) | windows-1251 |
Turkish (ISO 8859-9) | iso-8859-9 |
Turkish (Windows-1254) | windows-1254 |
Greek (ISO 8859-7) | iso-8859-7 |
Greek (Windows-1253) | windows-1253 |
Japanese (EUC-JP) | euc-jp |
Japanese (ISO-2022-JP) | iso-2202-jp |
Japanese (Shift-JIS) | shift_jis |
Traditional Chinese (Big5) | big5 |
Simplified Chinese (GB-2312) | gb2312 |
Korean (EUC-KR) | euc-kr |
Korean (ISO 2022-KR) | ISO 2022-KR |
Korean (KSC-5601) | ksc_5601 |
Thai (Windows-874) | windows-874 |
Thai (TIS-620) | tis-620 |