D
D
double_t0uble2019-09-13 14:08:16
Oracle
double_t0uble, 2019-09-13 14:08:16

How to convert cp1251 to utf8 in zabbix?

Hello!
I monitor Oracle through zabbix.

SELECT Nvl(Listagg(Reg_Date || Chr(13) || Er, Chr(13) || Chr(13) || Chr(13)) Within GROUP(ORDER BY Reg_Date DESC), '1') "Emp_list"
      FROM (
                        
                        SELECT MAX(j.Req_Start_Date) AS Reg_Date,
                                               j.Additional_Info AS Er
                              FROM dba_Scheduler_Job_Run_Details j
                        WHERE j.Owner || '.' || j.Job_Name = '{#JBN}'
                                         AND j.Status = 'FAILED'
                                         AND j.Req_Start_Date >= SYSDATE - 1 / 24
GROUP BY j.Additional_Info)

At the output in the logs - Cyrillic, in zabbix:
5d7b782008719993500366.png
In oracle -
5d7b78601dd68199308123.png
Mysql on zabbix encoding UTF8
How can I get Cyrillic in zabbix display???

Answer the question

In order to leave comments, you need to log in

1 answer(s)
I
idShura, 2019-09-13
@idShura

On the zabbix server, try setting the variable NLS_LANG = RUSSIAN_RUSSIA.CL8MSWIN1251

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question