At 11:17 AM 3/11/2004 +0000, you wrote:

>Hi folks
>
>Please help urgently!!!!
>When I use big varchar datafields on Windows as well as LINUX machines, I
>don't have any
>problems. But if I send the same query on a Mac OS X I got a error message.
>
>My envoirement: eMac G4 (also tried on ibook G4 with same problem), Mac OS
>10.3.5,
>FB1.5.1 CS Mac OS X
>
>1.) Create an new table with big varchars:
>
>CREATE TABLE CLIENTS (
> ID_CLIENT VARCHAR (6),
> TXT_ORDER_H VARCHAR (31000),
> TXT_ORDER_F VARCHAR (31000),
> OPID_NEW VARCHAR (6) );
>
>2.) Execute the query: "select * from clients;"
>
>3.) Result is: ".......Statement failed, SQLCODE = -901
>message length error (encountered -3494, expected 62042)"
>
>Stangely, doing the same query on the FB 1.0 Mac OS X Version, doesn't
>return a error at
>all.
>

The first thing I would want to check is: are you using the same character
set in the client and in the database (either DEFAULT CHARACTER SET at
database level or CHARACTER SET and COLLATE attributes at column level...

Make sure also that you are using the correct version of the client library.

./heLen