Overview

This is a comparison between varchar type and char type.

Version

Applicable to all versions of Altibase.

Comparison between VARCHAR and CHAR types

In the case of char type, 0x20 is added and compared based on the larger length when comparing, and when comparing char and varchar, the comparison is performed based on the valid data of varchar (position of 0x00).

Sometimes, when SESC coding, variables are initialized to 0x00 for varchar and 0x20 for char. There are rules above, so it is better to initialize them to 0x00.