LR database parameterized FETCH: The query result is an empty and same is the parameter file problem reason

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:

1. First make sure that the SQL can query the data

2. Make sure the database driver and the encoding of the normal Chinese character format are all fine.

3. Try other SQL statements, such as characters with spaces, kanji, numbers, English

4. 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