Hello!
I updated our Zabbix installation from 4.2 to 6 a few days ago. Since the update some queries against a MS SQL Server do not return the correct value. I found that the not working queries contains characters like ö,ä,ü.
I think it's a problem of the used charset / encoding.
Can someone tell me how to change the charset which is used for encoding the query string which is sent to the MS SQL Server?
odbcinst.ini
odbc.ini
Thank you very much for your help
I updated our Zabbix installation from 4.2 to 6 a few days ago. Since the update some queries against a MS SQL Server do not return the correct value. I found that the not working queries contains characters like ö,ä,ü.
I think it's a problem of the used charset / encoding.
Can someone tell me how to change the charset which is used for encoding the query string which is sent to the MS SQL Server?
odbcinst.ini
Code:
[ODBC Driver 17 for SQL Server] Description=Microsoft ODBC Driver 17 for SQL Server Driver=/opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.7.so.2.1 UsageCount=1
Code:
[myServer] Driver = ODBC Driver 17 for SQL Server Server = tcp:myserver,1433 Charset = UTF-8