Trailing spaces are returned by the database for a char() column, if the
inserted data is shorter than the fixed length. This is not the case with
a varchar or a text column.

Lets fix the Sybase extension as well and see how manu bugs we are getting
from this.

- Frank


> On Wed, 15 Oct 2003, Ilia Alshanetsky wrote:
> 
> >If in fact code will be broken then yes, INI directive may be the only
route. 
> >However, I do not see why trailing spaces were being stripped in the
first 
> >place, as the original report indicates it does technically 'corrupt'
the 
> >data?
> 
>     I'm -1000 on any new ini option. IMO, the behaviour of internally
>     modifying data is inherently wrong. Mysql does not strip any ws,
and
>     that has been the de facto standard which other db exts should
follow.
>     
>     And I can't find anything about this in the manual either.
>     I would expect that if I store '  foo  ' in database, I will
>     also get back '  foo  ' and not 'foo' or '  foo'.
>     
>     If other db exts do this, same fix should be applied to them too.
>     
>     --Jani
> 
> -- 
> PHP CVS Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
> 

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

Reply via email to