Conversions and changes to data lengths

In some cases, converting data between the server’s character set and the client’s character set results in a change to the length of the data, for example, when the character set on one system uses one byte to represent each character and the character set on the other system requires two bytes per character.

When character set conversion results in a change in data length, there are two possibilities: