zuckerreports show blank report result on reports with non-englsh characters in query

[rodnikosh]

I installed and using zuckerreport 2.0 in sugarcrm 6.5.5 with a much success.
i create my reports in Ireport 4.8.0 and run them in zuckerreports and everything works fine.

But when trying to make zuckerreport execute a report with Hebrew language characters (UTF-8) , I get a blank report.

For example, a report i created with this simple query show a blank report (0 results) on zuckerreport although it runs great (reuturn results) in Ireport and mySQL database:

SELECT
COUNT(leads.`lead_source`) AS Count_of_sources,
leads.`primary_address_city` AS leads_primary_address_city,
leads.`lead_source` AS leads_lead_source
FROM
`leads` leads
WHERE
primary_address_city = “תל אביב” and Deleted=0
GROUP BY
leads_lead_source

when running this report on zuckerreport i get a blank report in any situation where Hebrew Is in the query.

Any tip will help, i'm totally stuck...

[kir]

I installed and using zuckerreport 2.0 in sugarcrm 6.5.5 with a much success.


when running this report on zuckerreport i get a blank report in any situation where Hebrew Is in the query.

Any tip will help, i'm totally stuck...

Make sure that when you type your query in browser for zuckerreport - browser is setted to utf8 without cherset recognition. Don't do it by copy-paste. Not sure, but it might help (i hope)

kir