|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
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
September 9th, 2003, 06:42 AM
|
|||
|
|||
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.
|
|
#4
September 10th, 2003, 03:55 PM
|
||||
|
||||
|
Quote:
There were some problems with trim function in v1.5 (now solved) In what tool do you test this sql ? in isql ?
|
|
#5
September 11th, 2003, 09: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.
|
|
| Viewing: Dev Shed Forums > Databases > Firebird SQL Development > Select returns string with spaces. |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
