php+mssql: length of a field

eomer

Hello from Belgium,

I have a problem while querying a mssql database.

I perform a normal select on the DB, and fields containing more than 250 chars are truncated to 250 (I think it is 250?).

In the DB, the filds concerned are varchar(2000).

Is there a way to obtain the whole record?

Part of code is pasted below...

Thank's in advance,

Nicolas

// query

$sql = "select * from ViewCR order by Identifier desc";

// run the query
$req = mssql_query($sql);

while($data = mssql_fetch_array($req))
// Print-out
{
echo '<td width="250">'.$data['Identifier'].'</td><td width="450"><p align=justify>'.$data['Title'].'</p></td></tr><tr>';
echo '<td width="250"></td><td width="450"><p align=justify></p></td></tr><tr>';
}

eomer

I just read this on a faq :

"Basically mssql only returns 255 characters of a big text field. I have
no idea why."

How come??? Does any one know a work around?

Thank's in advance,

Nicolas

surfer

VARCHAR(length)
The maximum varchar length is 255. So you can't write varchar(2000). If you use VARCHAR columns to store long texts, trailing spaces will always be removed upon retrieval.

You can read more about it in the documentation
http://www.mysql.com/doc/en/CHAR.html

Hope it helps
🆒

surfer

Use TEXT fields insted

eomer

Thank's for your help,

Actually I am working with a Sql Server and not Mysql... so I think that the problem comes from somewhere else... 😉

Nicolas

EzPc

Originally posted by eomer
Hello from Belgium,

I have a problem while querying a mssql database.

I perform a normal select on the DB, and fields containing more than 250 chars are truncated to 250 (I think it is 250?).

In the DB, the filds concerned are varchar(2000).

Is there a way to obtain the whole record?

Part of code is pasted below...

Thank's in advance,

Nicolas

I think all you have to do is change the property in the column from VARCHAR to SMALLBLOB, MEDIUMBLOB OR LONGBLOB. At least those are the choices when working with MySQL 😃

Hope this helps...