[PHP-WIN] RE: MSSQL 7.0 and PHP

[Carlos Andre Marques Moreira]

I've seen this problem here before. Some guys posted this is a problem in
the mssql.dll, don't know if this has been fixed.
I had this problem here before, and i "fixed" it changing data type to TEXT

Carlos André

-----Original Message-----
From: Franco Breciano [mailto:[EMAIL PROTECTED]]
Sent: quarta-feira, 24 de outubro de 2001 00:02
To: [EMAIL PROTECTED]
Subject: MSSQL 7.0 and PHP


I'm using php to retrieve a Query from a SQLServer 7.0 database.

My code is this one:

$base = mssql_select_db($db,$conexion);

$sql="SELECT MarcasSolicitante FROM Marcas";

$result = mssql_query($sql,$conexion);

  while ($myrow = mssql_fetch_array($result))
  {
   $mensaje= $myrow["MarcasSolicitante"];

   ?>
    <p><strong><font size="4"><u>Mensaje:</u></strong> &nbsp &nbsp</u> <font
size="3"><?echo $mensaje;?> </font></a></P>
    <hr>

<....>
<....>

The problem is that the field MarcasSolicitante in the database is
VarChar(7000), and php receives a Char(255), what I'm I doing wrong? Isi
there any parameter I can modify in order to retrieve correctly the fields??

Thanks in advance