Subject Re: [Firebird-Java] CHAR and VARCHAR
Author David Jencks
I would not recommend Interclient, but often recompiling in your
environment will help with the wrong protocol version errors. There's an
ant script somewhere in our interclient source tree that should build both
Interclient and Interserver for you, it worked at least on earlier redhat
linux versions.

david jencks

On 2002.07.30 09:47:12 -0400 Leos Urban wrote:
> >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
>
>
>
>
> To unsubscribe from this group, send an email to:
> Firebird-Java-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>
>