I ran into strange problem - I use check_mysql_query to retrieve the result and check it against threshold. Everything works perfectly, until I had to add filter in SQL query and use specific field value, which is in local language (Japanese). In this case check_mysql_query always returns 0:
My test from command line:
Code: Select all
./check_mysql_query -q "SELECT count(order_id) number_of_orders FROM oc_order WHERE payment_method = '銀行振込' AND order_status_id = 2 AND date_added > DATE_SUB(NOW(), interval 10 minute)" -H XXX.XXX.XXX.XXX -u data_check -p YYYYYYY -d ocdb
Code: Select all
QUERY OK: 'SELECT count(order_id) number_of_orders FROM oc_order WHERE payment_method = '銀行振込' AND order_status_id = 2 AND date_added > DATE_SUB(NOW(), interval 10 minute)' returned 0.000000 | result=0.000000;;;
Any ideas how to resolve it?
Thanks in advance and a great day to everyone.
Sergii