Business Analytics Connect, learn and share with over 10000 users across the IBM Business Analytics. Ask a question
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,
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
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.