Database char(8) returning Character

vermule · **Joined:** Mon Mar 02, 2009 3:06 pm **Posts:** 5

I am trying to use SQLQuery and we have a column that is a char(8) and our internal mappings map it to a java.lang.String. I am trying to do a fetch using the SQLQuery object and it is only returning the first character of the char field.

Is there a way to return the whole column and not just the first character?

mmerder · **Posted:** Wed Mar 04, 2009 5:08 am

Probably the simplest solution is to convert your char-column to a varchar within your native query.

vermule · **Joined:** Mon Mar 02, 2009 3:06 pm **Posts:** 5

I've never had to do that before, can you give me an example how?

mmerder · **Posted:** Wed Mar 04, 2009 11:30 am

I think it depends on your database. Normally its like "select CAST ( yourCharColumn AS varchar(8)) as yourColumn from..."

vermule · **Joined:** Mon Mar 02, 2009 3:06 pm **Posts:** 5

kudos to you!!!

It works now.

Thanks.