Strange characters in SQL Server using HS

TheLonelyDBA

    Oracle 11.2.0.4 Std

    SQL Server: sql express 2017, Finnish_Swedish_CI_AS

    init.ora file used for the HS:

     

    HS_FDS_CONNECT_INFO     = TestHS

    HS_FDS_SHAREABLE_NAME   = /usr/lib64/libodbc.so.2.0.0

    HS_FDS_SUPPORT_STATISTICS       = FALSE

    HS_LANGUAGE                     = SWEDISH_SWEDEN.UTF-8

    HS_NLS_NCHAR                   = AL32UTF8

    HS_FDS_SQLLEN_INTERPRETATION    = 64

    set ODBCINI=/etc/odbc.ini

    set LD_LIBRARY_PATH=/usr/lib64:/app/product/11.2.0.4/db/lib

     

    We are seeing strange characters when using 'åäö'.

     

    Any ideas?

     

    Regards

    TheLonelyDBA