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

Question stats

	Ask Question
Home Questions Articles Browse Topics Latest Top Members FAQ