|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
|
|||
|
|||
|
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
|
||||
|
||||
|
in what version of the server :
Firebird 1.0 or Firebird1.5 ? |
|
#3
|
|||
|
|||
|
I use version 1.0.3. Does it make any problem?
|
|
#4
|
||||
|
||||
|
Quote:
There were some problems with trim function in v1.5 (now solved) In what tool do you test this sql ? in isql ? |
|
#5
|
|||
|
|||
|
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. |
![]() |
| Viewing: Dev Shed Forums > Databases > Firebird SQL Development > Select returns string with spaces. |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|