The cause of this problem:
is because our query results exist in Chinese
If the query results are not Chinese, the display is normal
Workaround:
Create a new data source:
Re-select this data source and query again:
Description is not a problem with the connection string or is a MySQL-driven issue
Problem 2:data Retriever failed to execute query solution
Problem phenomenon:
All environments are the same, just two SQL statements are different:
Select ProductName from sp_product where productname= ' cialis permanent tender skin soap 115g ' This sentence executes:
Select ProductName from sp_product where productname= ' heart-flavored orchard 200g salt baked green peas ' The SQL Executive newspaper said the error
Solution Ideas:
First make sure that the SQL can query the data
Make sure the database driver and the encoding of the normal Chinese character format are all fine.
Try other SQL statements, such as characters with spaces, kanji, numbers, English
Finally if still not solved, may be some words of the Chinese encoding deviation caused, MySQL encoding than the general range of small
Select ProductName from sp_product where productname= ' heart-flavored orchard 200g salted green peas '
Select ProductName from sp_product where ProductName like ' heart fruity% '
Select ProductName from sp_product where ProductName like ' heart-flavored Orchard 200g% '
Try one word at a word:
Summary: For some words in the Chinese coding deviation caused by, like instead of bypassing
Problem solved:
LR database parameterized FETCH: The query result is an empty and same is the parameter file problem reason