mssql Field Length Limitation of 4k ?

admin

Administrator
Staff member
My application must process HL7 messages stored in on SQL Server. The entire message is stored in a single field, and can be quite large (~50k). Using mssql_fetch_array, the field returned is being truncated to 4k, with the remaining message content being trimmed off- big problem. I am using phpDB to access mssql, perhaps this is a related issue.

Is there anyway to adjust this limitation, or does anyone has a reasonable workaround to this problem? Thanks.
 
Back
Top