Thanks ./heLen

The table "client" was created in the default character settings, at
least I haven't set anything.

The database settings is "none" (default).

I think it has to be something else because the table is empty and
doesn't contain any data and therefore a query on the table should
return empty fields and especially not any special characters.

Halit



--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
wrote:

> 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