char_length()/octet_length() for char() datatype returns a character
length *except* the trailing blanks. Is this what the standard
expects? Oracle's length() returns 3 in the case below.
test=> create table t2 (c char(3));
CREATE
test=> insert into t2 values('c');
INSERT 277385 1
test=> select * from t2;
c
-----
c
(1 row)
test=> select char_length(c) from t2;
length
--------
1
(1 row)
test=> select octet_length(c) from t2;
octet_length
--------------
1
(1 row)
--
Tatsuo Ishii