This was posted in the PHP section also...
"Two spaces" with 2 white spaces in the middle.
When I use this code:
$sql = "select Name FROM Name_TBL WHERE Number = '$Num"; $rs = mssql_query($sql); $RT = mssql_fetch_array($rs); $Name= $RT[Name'];
In the DB, and when I use another query analyzer, I get the correct return of "Two spaces" with 2 white spaces in the middle.
BUT...in PHP when I echo $Name, one of the two spaces has been deleted.
So I echo "Two spaces" with 1 white spaces in the middle.
I need the varchar to be exactly like it is in the DB, and I CANNOT change the data to one space.
Does anyone know what is causing this? Is there someting in the php.ini file that would do this?
PLEASE HELP I AM STUCK!!