Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Strange characters in SQL Server using HS

TheLonelyDBAOct 25 2019 — edited Nov 6 2019

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

Comments
Post Details
Added on Oct 25 2019
7 comments
576 views