PHP & MS-SQL Problem

[admin]

Hiya all,

I have run into a problem that has me stumped. (read newbie)

I have a MS-SQL table, tblStory, configured as follows:

---------------------------
tblStory
---------------------------
SSID int(4)
SSID int(4)
CID int(4)
Heading char(50)
Story typSTR_DESC_XLarge(varchar)(4000) [User defined data type]
ImageName Char(50)

I can INSERT with no problems. However, when I do a SELECT, either with PHP or MS Query Analyzer, the field tblStory.Story gets truncated to about 256 chars. What am I missing?

In PHP, I use the mssql_functionname Functions.

Thanks in advance.

HOGI!