How can I insert over 3400 bytes of text into a field in the Tridion broker? -

How can I insert over 3400 bytes of text into a field in the Tridion broker? -

i have schema lot of metadata fields. want able search components based on schema broker via tridion api like:

using tridion.contentdelivery.dynamiccontent.query; private static criteria getsearchcriteria( string searchtext, params brokerconstants.metadatafield[] fields) var searchcriteria = new list<criteria>(); foreach (var f in fields) { var mkctext = new custommetakeycriteria(f.name); var mvctext = new custommetavaluecriteria( mkctext, "%" + searchtext + "%", criteria.like); searchcriteria.add(mvctext); } homecoming new orcriteria(searchcriteria.toarray()); }

this works fine far: user can type in search text, pass search text through tridion via broker api, , tridion gives components match search text.

but! if add together lot of text content field component, tridion publishing process fails @ "deploying" phase:

phase: deployment processing phase failed, not deploy component [component id=tcm:9-2617-16 title=xyz schema=tcm:9-2325-8], custommeta field, stringvalue, bigger supported size of 3400 bytes!

i tried changing key_string_value column in broker databases's custom_meta table nvarchar(3400) nvarchar(max), doesn't seem have fixed problem.

i'm not exceeding limit much @ all: "wc" tells me there 4037 bytes in text. around 6000 or sounds comfortable-ish upper limit needs.

is there easy way increment amount of bytes of text i'm allowed in field?

there no supported way of doing wish accomplish. also, maintain in mind actual purpose of custom meta. seems me you're misusing adding huge content in column.

anyways, if want go downwards road, need contact tridion back upwards or visit sdltridionworld (login required) , download cd_2011.1.1.83467 (or hotfix containing cd_2011.1.1.81125 except cd_2011.1.1.83475!!!). hotfix changes removes hard check on size of metadata done @ deployment time. in other words, allows shoot in leg letting database server decide if allowed store much content in column. please know changing database columns not supported tridion.

hope helps.

tridion tridion-2011 tridion-content-delivery