hibernate query returns only first character of string

Question

When I run a query like this in oracle 10g using sqldeveloper, it runs fine.

select 'Canada' as "country", emp.name as "name" from emp.

Gives me the name and country. When I run it in hibernate as a named query, I get only 'C' instead of 'Canada' for "country".

Why is this so?

Answer 1

select cast('Canada' as varchar2(100)) as "country", emp.name as "name" from emp