strange signs on production system

[enigma]

I am having problems with report on the production system, locally works everything fine. I have tested the query locally and on the production and this is also fine. The problem I am facing are strange signs, like hashed value. Example taken screenshot from production and the other one where I get a strange sign LQ==, example:

ScreenShot035.png (11.88 KiB) Viewed 2994 times

Any help would be appreciated.

[enigma]

this is only happening when I am using GROUP_CONCAT in MySQL. All other fields are shown OK, but by those fields which are gotten from GROUP_CONCAT I get this strange signs

[HighAley]

Hello.

Could you send us a sample which reproduces the issue for analysis?

Thank you.

[enigma]

I have faced the same problem again and found the error. In MySQL database when data is type TEXT than value is shown like I attached it in the photo above, when I change it to VARCHAR it is shown normally, please check this and let me know is there a way to solve it.

[Alex K.]

Hello,

If you are using grouping in SQL query, it is sometimes not possible to automatically determine the type of the field, and the designer automatically detects them as binary data.
Please try to check the last prerelease build. Also please try to set the byte[] type for the column.

Thank you.