#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2003
    Posts
    10
    Rep Power
    0

    Red face 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.
    Last edited by loudo; September 10th, 2003 at 05:58 AM.
  2. #2
  3. Bug Hunter
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2003
    Location
    Transylvania (Romania)
    Posts
    309
    Rep Power
    24
    in what version of the server :
    Firebird 1.0 or Firebird1.5 ?
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2003
    Posts
    10
    Rep Power
    0
    I use version 1.0.3. Does it make any problem?
  6. #4
  7. Bug Hunter
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2003
    Location
    Transylvania (Romania)
    Posts
    309
    Rep Power
    24
    Originally posted by loudo
    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 ?
    My home page: http://www.firebirdsql.org and work place :http://www.reea.net
  8. #5
  9. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2003
    Posts
    10
    Rep Power
    0

    Unhappy


    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.

IMN logo majestic logo threadwatch logo seochat tools logo