converting Byte[] to string

[dingchakbelled]

I am trying to display the results of a MYSQL query that contain a byte array as string. I have tried changing the output encoding to UTF-8' through the report designer, but the values still come out as a byte array. Is there any other place in the report designer that lets me control the output encoding in the designer?

[Taqua]

Byte-Arrays are no strings. They are binary data and we have no way to handle them. In the database world, char or varchar or clobs are used to transport text.

You can tell the database to convert your binary data into strings via either "CAST(field as STRING)" or "CONVERT(field using UTF-8)".

@see your database manual:
http://dev.mysql.com/doc/refman/5.0/...nction_convert