Thanks for the reply. This parameters seem to be Planning Analytics on prem. I forgot to put the technology I'm using in the original question. I am using planning Analytics on cloud and Secure Gateway connection to SQL database located on AWS cloud. I haven't found something similar when setting up Secure Gateway connection.
------------------------------
Anja Pećnik
------------------------------
Original Message:
Sent: Fri December 08, 2023 12:23 AM
From: NIGEL CAMPBELL
Subject: ODBC Output character set
Have you set the option that causes the W (wide) API calls to the ODBC driver manager to be used re character data?
https://www.ibm.com/docs/en/cognos-analytics/12.0.0?topic=connections-odbc-connection-parameters
------------------------------
NIGEL CAMPBELL
Original Message:
Sent: Thu December 07, 2023 05:37 AM
From: Anja Pećnik
Subject: ODBC Output character set
Hi,
I have a problem with ODBC output. Special characters for Croatian aren't displayed correctly in the database after ODBC output.
While exporting Company name from dimension 'č' is changed to '?' in SQL query that is later used for ODBC output.
With text output I can fix this problem using SetOutputCharacterSet function by setting 'TM1CS_UTF8' as default character set. Is there a similar function for ODBC output?
I have tried changing the language of the machine but setting Croatian as default doesn't fix the problem.
Have any of you had similar issues? Do you have any suggestions how to fix this?
Changing to non Croatian characters isn't an option.
Thanks in advance,
Anja
------------------------------
Anja Pećnik
------------------------------