Strore large texts in mssql and dispaying them in php

mikek12004

I have a text field where I wish to enter a large text around 8000 words and a div where I want to diplay it.
To save I have a textarea with post I gaet the text and save it using a simple

Expand|Select|Wrap|Line Numbers

insert into clroot.descriptions (desc) values ('$text')

$test is the PHP variable holding the text.
Storing is OK but when displaying It cuts me also some chahracters I use

Expand|Select|Wrap|Line Numbers

select CONVERT(TEXT,descr1) from clroot.descriptions where id='1.00930'

to show the data but the data in the table is e.g. 6332 chars and I see only the 4086 chars

ck9663

What's the structure of your table? Can you increase the size of your column?

-- CK

mikek12004

id varchar(50)
desc1 varchar(8000)
desc2 varchar(8000)
desc3 varchar(8000)

in this table I want to store/display the biggest text possible what should I put to the column type? And will I have problems displaying in php?

mikek12004

I indded have a problem displaying them in PHP, when I use

Expand|Select|Wrap|Line Numbers

 
$ree=mssql_query("select descr1 from clroot.descriptions where id='1.00930'");

echo $ree[0];

even though the descr1 is a column with TEXT type when I do the echo I get a very trimmed version of the text.
The same result I have with

Expand|Select|Wrap|Line Numbers

 $ree=mssql_query("select CONVERT(TEXT,descr1) from clroot.descriptions where id='1.00930'");
 

code green

The same thing occurs with Access data and php.
I think it is a known php bug but check this out
manual

Strore large texts in mssql and dispaying them in php

Post your reply

Similar topics