[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2934?page=c... ] Max Rydahl Andersen commented on HHH-2934: ------------------------------------------ need to tell what kind of query you are actually executing here. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2934?page=c... ] Mike Farewell commented on HHH-2934: ------------------------------------ I think I have found a similar case: org.hibernate.Query q = hibernateSession.createSQLQuery( "select distinct c.alpha_2, c.alpha_3, cl.country_name, c.country from countries c " + "inner join country_locale cl on c.alpha_2 = cl.country_alpha2 where " + "cl.language_code = ? order by cl.country_name"); q.setString(0, locale); results = q.list(); returns an array of objects the first two items of which are char objects with only one char in them i.e. should return "AD";"AND";"Andorra";"Andorra" "AE";"ARE";"United Arab Emirates";"United Arab Emirates" "AF";"AFG";"Afghanistan";"Afghanistan" ... actually get "A";"A";"Andorra";"Andorra" "A";"A";"United Arab Emirates";"United Arab Emirates" "A";"A";"Afghanistan";"Afghanistan" ... The database I am using is postgresql 8.2 my postgresql database table has the following definition: CREATE TABLE countries ( country character varying(50) NOT NULL, numeric_code smallint NOT NULL, alpha_3 character(3) NOT NULL, alpha_2 character(2) NOT NULL, CONSTRAINT pk_countries PRIMARY KEY (alpha_2), CONSTRAINT un_alpha_2 UNIQUE (alpha_2) ) The work around is to cast the char fields to varchars in the select: e.g. CAST(c.alpha_2 as varchar) -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2934?page=c... ] Juan F Cervera commented on HHH-2934: ------------------------------------- I had the same problem with Informix 10. The solution proposed above by Mike Farewell works fine but, at least in Informix, you need to specify the size of the varchar in the casting or else it will continue to return just one character. E.g. In the example above where alpaha_2 is size 2, you'd need to change the select an say: cast(c.alpha_2 as varchar(2)) Hope it helps -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira