September 9th, 2003, 07:42 AM
Select returns string with spaces.
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.
Last edited by loudo; September 10th, 2003 at 06:58 AM.
September 10th, 2003, 04:23 AM
in what version of the server :
Firebird 1.0 or Firebird1.5 ?
September 10th, 2003, 04:32 PM
I use version 1.0.3. Does it make any problem?
September 10th, 2003, 04:55 PM
There were some problems with trim function
in v1.5 (now solved)
In what tool do you test this sql ? in isql ?
September 11th, 2003, 10:20 AM
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.