Special Characters replaced with ?

Technote (troubleshooting)


Problem(Abstract)

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

This document describes how to resolve this.

Symptom

Special language characters replaced by ?.


Cause

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.

Environment

Windows
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.

Rate this page:

(0 users)Average rating

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:

2014-03-03

Translate my page

Machine Translation

Content navigation