mssql empty (not null) varchar fields

From: Date: Tue, 06 Feb 2001 13:39:15 +0000
Subject: mssql empty (not null) varchar fields
Groups: php.windows 
Request: Send a blank email to php-windows+get-5410@lists.php.net to get a copy of this message
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

« previous php.windows (#5410) next »