>I traced through the code and discovered the
> SQLDA->sqlvar[0]->sqltype is getting changed to 448
> (SQL_VARYING) when the isc_dsql_prepare() is run. By
> setting it back to 453 (SQL_TEXT + 1), I get the
> correct output.
>
> Can anyone explain why the prepare statement is
> changing the data type?

Are you aware that VARCHAR data are transmitted in actual
length, while CHAR in full declared length ?

Ivan
http://www.volny.cz/iprenosil/interbase/