Hey,

IB7 (?) started support column names with a max of 67/68 characters,
IBO (TIBOQuery) fails:

CREATE TABLE LONGCOLUMNAMES
(
ID INT,
C23456789012345678901234567890 INT,
C234567890123456789012345678901 INT,
C2345678901234567890123456789012 INT,
C23456789012345678901234567890123 INT,
C234567890123456789012345678901234 INT,
C2345678901234567890123456789012345 INT
);

COMMIT;


select
*
from
LONGCOLUMNAMES

As you can see the resultset has multiple column names with
C234567890123456789012345678901.


Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB,
Oracle & MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com