sql & trim problem
| From: | Dale Hersowitz | Date: | Tue, 19 Oct 2004 04:43:18 +0000 |
| Subject: | sql & trim problem | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-199782@lists.php.net to get a copy of this message | ||
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