Hibernate 4.2.2, Informix 11.5
Unique constraint for a varchar colum generated by hibernate:
alter table CONTENT_TYPE add constraint UK_bj57mo7jmskov9s34ylf5wa18 unique (TYPE)
According to the Informix doc the unique constraint name should be at the end.