Welcome to Knowage Q&A, where you can ask questions and receive answers from other members of the community.
+2 votes
1 view

Hi 

When I have executed a SQL query such as (SELECT * FROM `mornings` where oncall='خیر') in mysql it returns me some records.

but when I have used the query (exactly same query) in the knowage it returns “Query returns no data”.

More accurate, in the “where” clause when I have used value in a field in English in the knowage it returns data. But if I have used value in a field in Persian in the knowage it returns no data (while the same query in mysql returns data).

Please help me that I find my problem.

Best regards,

bahar

Environment Knowage-6_2_1-CE-Installer,Windows7, Chrome
in Data Set by (730 points)

1 Answer

0 votes
I have the same problem too but with Chinese character.  Please knowage team fix this issue.

thanks.
by (810 points)
Is the database and application-server set to support UTF-8 character-set?
...