Wrong return type for UNLIST: CHAR(32) should be VARCHAR(32)

[mrotteveel]

The documentation of UNLIST (in README.unlist), states (emphasis mine):

2. <data-type>: target data type to convert the output values into. Alternatively, a domain can be specified as the returned type. If omitted, VARCHAR(32) is implied.

In reality, UNLIST defaults to CHAR(32).

I think the padding behaviour of CHAR is undesirable for this function, and it should default to return VARCHAR as stated in the documentation.

[mrotteveel]

Related to this: I think the fixed default is a mistake. I started a discussion on firebird-devel: UNLIST default data-type

[aafemt]

As was concluded in the previous discussion of this subject, default return type is wide enough to contain any integer data, which is the primary purpose of this function.

[mrotteveel]

@aafemt Please post that comment in the firebird-devel thread, not here.

Though I observe there the last remark is that it should be VARCHAR(60), not VARCHAR(32).