Uncompressed columns are shown in hex instead of char type

Following query results into wrong output Q1. Q1 is shown as hex output, but ist should be the string Q:

select distinct 
a.Rows,length(uncompress(a.Query)) n
,uncompress(a.Query) Q1
,cast(uncompress(a.Query) as char) Q
from MyTable a

A more simplified query example is:

select cast(uncompress(compress('abc')) as char) as test

Without cast expression you'll get hex output too, but it should be character...

(HeidiSQL, Ver. 9.4.0.5174)

I cannot reproduce in MySQL/5.5.46. What's your server version?

If I recall correctly, MySQL server incorrectly reports some text columns as binary now and then and it eventually gets fixed in later releases. If that's the case, you can use the "View binary data as text (instead of HEX)" as workaround.

MySQL version is 5.6.27

Weird... I have access to a 5.6.22 server where it doesn't happen either :-?