If a table is created with of field of type CHAR of a defined length as follows:
create table myTable (id char(36) not null, version integer, creationDate timestamp not null)
And the CHAR field is defined in a simple SELECT query as follows:
SELECT id FROM myTable
Only the first character of the field value is returned. In essence, the field is treated as a CHAR, not a CHAR(36).