Re: [PHP] sql trim problem

2004-10-19 Thread Greg Donald
On Mon, 18 Oct 2004 21:43:18 -0700, Dale Hersowitz
[EMAIL PROTECTED] wrote:
 Recently, I had to format my db server and when I re-attached the database,
 I noticed some unusal behavior. I have some fields in certain tables with a
 width of 60. When I would extract data from the table for that specific
 field, the data would contain extra blank chars. As a result, I am forced to
 use the trim function to get rid of the extra chars. This problem has never
 occured before and I now find it quite annoying. Does anybody have any
 ideas?

This question would be more appropriate for php-db or the mailing list
for the database you are using, if one exists.

Fixed length fields often have 'filler' data at the end of the field. 
I suspect this the case with your data.


-- 
Greg Donald
Zend Certified Engineer
http://gdconsultants.com/
http://destiney.com/

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP] sql trim problem

2004-10-18 Thread Dale Hersowitz
Recently, I had to format my db server and when I re-attached the database,
I noticed some unusal behavior. I have some fields in certain tables with a
width of 60. When I would extract data from the table for that specific
field, the data would contain extra blank chars. As a result, I am forced to
use the trim function to get rid of the extra chars. This problem has never
occured before and I now find it quite annoying. Does anybody have any
ideas?

Thanks,
Dale

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php