Necuima Posted June 13, 2018 Share Posted June 13, 2018 (edited) Hi Larry, Am doing exercise 4 page 223 but my results show the counts in hex. Localhost/HeidiSQL/MariaDB 10.1.31. How can I force the counts show normally? Thanks P.S., for the following exercise, bottom right page 223 (results G) the numbers show normally. Edited June 13, 2018 by Necuima Additional information Link to comment Share on other sites More sharing options...
Necuima Posted June 13, 2018 Author Share Posted June 13, 2018 OK, found the issue - HeidiSQL has a button to set to "view binary data as text" though why this would only be needed for this query seems odd - but in nutshell, this issue is solved. Cheers from Oz Link to comment Share on other sites More sharing options...
Larry Posted June 13, 2018 Share Posted June 13, 2018 Ah, kudos for figuring that out and thanks for sharing. I'm not familiar with HeidiSQL so I probably wouldn't have known that was the cause! Link to comment Share on other sites More sharing options...
Recommended Posts