WYSYWIG character limit (asset builder)

Squiz Matrix Support
1

We have an asset builder that creates event assets works well, however we got an error today one user submited a form didn't get any confirmation.


When I look at Log manager this is what I see:

[codebox]INSERT INTO

Raw Entry: sq_sch_idx

Raw Entry: (

Raw Entry: value,

Raw Entry: type_code,

Raw Entry: type,

Raw Entry: assetid,

Raw Entry: component,

Raw Entry: score

Raw Entry: )

Raw Entry: VALUES

Raw Entry: (

Raw Entry: 'pspannbspspanspanbspan11amspanspanspannbspspanspanbspanspanspannbspnbspnbspnbspspanspanspanspann

bspnbspnbspnbspnbspnbspnbspnbspnbspnbspnbspspanspannbspnbspnbspnbspnbspnbspnbspnbspnbspnbspnbspnbspnb

spnbspnbspnbspnbspnbspnbspnbspnbspnbspnbspnbspnbspnbspnbspnbspnbspnbspnbspnbspbspanspannbspspan',

Raw Entry: 'calendar_event_single',

Raw Entry: 'wysiwyg',

Raw Entry: '20752',

Raw Entry: 'attr:description',

Raw Entry: 10

Raw Entry: ) [nativecode=ERROR: value too long for type character varying(255)] (LINE 695 IN /packages/search/search_manager/search_manager.inc) [SYS0270]

[/codebox]



It is a WYSYWIG field,



Is there a character limit?

2

There is no character limit for WYSIWYG cells, however there is a 255 character limit for words in the search index. It looks like the user has pasted in some content from an external source and not run the Replace Text tool, so all the bad HTML has been retained (lots of nbsp; instead of actual spaces, so the indexer can't break the words properly).
3

you are spot on