Re: Question about Double Encoding

[Rick James]

83 _decimal_ = 'S'
83 _hex_ = 131 _decimal_ = florin (the small f with hook) in the Windows. Search for 131 on
http://www.cs.tut.fi/~jkorpela/www/windows-chars.html

> when we looked at the selected columns through the MySQL command line client ...
> How was the client able to correctly interpret it?

When you did that, the terminal window did some decoding. The only way to safely see what is in a table is to do SELECT HEX(...). Alas, that only gives you the hex, and does not give you the decoding for it.

Also, look at the SELECT LENGTH(...), CHAR_LENGTH(...) for more clues.