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

0

i create my reports in Ireport 4.8.0 and run them in zuckerreports and everything works fine (zuckerreport is like jasper server but for using in SugarCRM).
Everything works fine and the ireport jrxml files presented great in zuckerreport , just like it does in Jasper Server.

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 (return 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 characters (UTF-8) are in the query.
 
Any idea will help, i'm totally stuck... 

rodnikosh's picture
Joined: Nov 6 2012 - 12:56am
Last seen: 6 years 9 months ago

0 Answers:

No answers yet
Feedback
randomness