Re: mssql empty (not null) varchar fields
| From: | Frank M. Kromann | Date: | Tue, 06 Feb 2001 16:52:23 +0000 |
| Subject: | Re: mssql empty (not null) varchar fields | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-5418@lists.php.net to get a copy of this message | ||
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: php-windows-unsubscribe@lists.php.net
>For additional commands, e-mail: php-windows-help@lists.php.net
>To contact the list administrators, e-mail: php-list-admin@lists.php.net
>
>
>