IBM Support

Special Characters replaced with ?

Technote (troubleshooting)


Using ODBC data source connection special language characters are replaced by a question mark (?).

This document describes how to resolve this.


Special language characters replaced by ?.


When using ANSI ODBC driver manager, the characters received from the driver manager are bounded to the the ANSI client locale, ie OS locale.

For example case, the the character ő ( letter O with double accute accent) is not in CP1252 code page on Windows. The character failed to translate to the codepage 1252.


ODBC Data Source

Resolving the problem

In order to receive the characters in Unicode, customers are advised to use Unicode driver manager. To enable Unicode driver manager, in the connection string for a Netezza datasource, add the keyword @UNICODE as below

(dblogicname "GOSALES" "DSN=DataSource;UID=udmsqc2;PWD=password@UNICODE" NZ )

For the generic ODBC datasource in the portal, there is a check box "Unicode ODBC". So we don't need manually to add the keyword @UNOCODE.

Document information

More support for: Cognos Business Intelligence
Cognos Viewer

Software version: 10.1, 10.1.1, 10.2, 10.2.1

Operating system(s): Windows

Reference #: 1665862

Modified date: 03 March 2014

Translate this page: