This is a comparison between varchar type and char type.
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.