Subject | Bug? error on macOSX at query on table with big varchar columns |
---|---|
Author | halitevli |
Post date | 2004-11-03T11:17:27Z |
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.
Thanks in advance !!!!
Halit
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.
Thanks in advance !!!!
Halit