7 Replies Latest reply on Nov 6, 2019 11:52 AM by mxallen-Oracle

    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