IBM Business Analytics

 View Only
  • 1.  ODBC Output character set

    Posted Thu December 07, 2023 04:09 PM

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


  • 2.  RE: ODBC Output character set

    Posted Fri December 08, 2023 12:23 AM

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



  • 3.  RE: ODBC Output character set

    Posted Fri December 08, 2023 05:36 AM

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