Re: sql & trim problem

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux