<para>

Values of type <type>character</type> are physically padded

with spaces to the specified width <replaceable>n</>, and are

stored and displayed that way. However, the padding spaces are

treated as semantically insignificant. Trailing spaces are

disregarded when comparing two values of type <type>character</type>,

and they will be removed when converting a <type>character</type> value

stored and displayed that way. However, trailing spaces are treated as

semantically insignificant and disregarded when comparing two values

of type <type>character</type>. In collations where whitespace

is significant, this behavior can produce unexpected results,

e.g. <command>SELECT 'a '::CHAR(2) collate "C" < 'a\n'::CHAR(2)

returns true.

Trailing spaces are removed when converting a <type>character</type> value

to one of the other string types. Note that trailing spaces

<emphasis>are</> semantically significant in

<type>character varying</type> and <type>text</type> values, and

len2;

intcmp;

len1=bcTruelen(arg1);

len2=bcTruelen(arg2);