Subject | Re: [Firebird-Java] CHAR and VARCHAR |
---|---|
Author | Leos Urban |
Post date | 2002-07-30T13:47:12Z |
>You should expect a string of n chars when retrieving a CHAR(n) field froma database.
Ok. But then there is incompatibility with Interclient based applications...
>Rewrite your SQL queriesDoes not help me - the same effect.
>SELECT CAST( CHARFIELD AS VARCHAR(n) ) AS CHARFIELD FROM ATABLE
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