Subject Re: [Firebird-Java] CHAR and VARCHAR
Author Leos Urban
>You should expect a string of n chars when retrieving a CHAR(n) field from
a database.

Ok. But then there is incompatibility with Interclient based applications...

>Rewrite your SQL queries
>SELECT CAST( CHARFIELD AS VARCHAR(n) ) AS CHARFIELD FROM ATABLE

Does not help me - the same effect.
Only trim() is solution (or changing DB to VARCHAR).

Maybe this is feature (that CHAR returns full length), but when I have
CHAR(2) then I get string with 6 character. It looks as a bug with Unicode?
Because I doesnt have time I prefer change DB structure to VARCHAR.

I am in bad situation, because with my new installed Redhat 7.3 server and
new Firebird server does not work Interclient -some Exception about wrong
protocol version. I tested both interclient.jar from ibphoenix with same
effect.
It means - I need go to new JDBC :-))

Thanks
Leos