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
