I have the following problem. I wrote a small app which exports records as insert statements for an oracle database.
As long as I use queries, which return just the columns, everything works fine and the type is properly determined. However, when I use constants in the query, then only the first character is returned as Character[1] object instead of the string.

As an Example:
select * from customer;

works fine. The name of the customer is printed correct.

select 'DummyName' as Name from customer;

returns only Character[1] = 'D'. The problem is, because of the nature of the application is to run any valid SQL query, I can not know which datatype is expected and therefore I can't specify the type beforehand.

Is there a solution to this problem?