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
Start a new discussion in EJB3 at Community