Re: sql & trim problem

On Mon, 18 Oct 2004 21:43:18 -0700, Dale Hersowitz <dale_news@hershonline.com> 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/