The PHP extension for MSSQL shoud strip leading and trailing spaces, but I check the
code and fix it if there is an error.
- Frank
>Hello,
>
>>From habbit and an unexplained hate to NULLs I do not use them in my
>databases.
>I use varchar fields with empty strings ('') instead.
>However MSSQL via the php4 module, returns these values as a single space
>character,
>and it forces me to trim all the returned varchar fields, before using them.
>
>This happens only if I query the database from php. In the query analyzer,
>the empty varchars
>are returned as empty strings.
>I have tried to call SET ANSI_PADDING off, before quering the database, but
>no change.
>
>Do you have any clues?
>
>vmp
>
>
>
>
>--
>PHP Windows Mailing List (http://www.php.net/)
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
>
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
