Select returns string with spaces.

Hello!
I would like to share my problem :

Select string from table; returns : "theString _ _ _ _ _ _ _ _ ..." (theString with spaces. )

string is defined as varchar(100) and output is 32 000 chars long.


I get the same output using trim(string). It is always 32 000 chars long.


Does anyone have the same problem? Thank you.

in what version of the server :
Firebird 1.0 or Firebird1.5 ?

I use version 1.0.3. Does it make any problem?

There were some problems with trim function
in v1.5 (now solved)
In what tool do you test this sql ? in isql ?

I test it in isql, but the problem occurs using PHP, too.

I tried to make my UDF trim for this. The problem is , that function gets only 100 chars and outputs only 100 chars, but after completing query output is again 32Kb.

Funny is, that, consulting this problem with people working professionally with firebird, nobody knows what I am talking about. This is a magic problem. I'll install newest version of Firebird. Hope will be OK.