Jackie Li [https://community.jboss.org/people/lwpro2] created the discussion "Re: Problem with native query" To view the discussion, visit: https://community.jboss.org/message/734193#734193 -------------------------------------------------------------- seems native query treat char as Character. solution1: use query.unwrap(SQLQuery.class) solution2: simply cast the column to varchar, cast(LAE.legalAccessEntityCode as varchar(12)) -------------------------------------------------------------- Reply to this message by going to Community [https://community.jboss.org/message/734193#734193] Start a new discussion in EJB3 at Community [https://community.jboss.org/choose-container!input.jspa?contentType=1&...]