Re: SQL-NS and the BLOB data type
Event data (as well as other SQLNS data) is stored as rows in a table in
the SQL Server database. This allows SQLNS to process subscriptions and
events in sets using joins rather than processing each subscription
individually as a query. This is what makes SQLNS scale so well.
I'm sure you already know that TEXT and IMAGE columns not stored or
handled in the same manner as other datatypes such as INT or VARCHAR.
TEXT and IMAGE columns require special functions and statements to
insert and retrieve the data store in those columns. SQLNS does not have
the complexities of dealing with those datatypes built in.
So to answer your question....no you cannot define event fields as TEXT
But all is not lost. Consider passing an ID column in for the event and
then get the data from the original datasource during formatting instead.
SQL Server MVP
Get up to speed quickly with SQLNS
In the ADF where you define your event data and the associated data
type, can event data be a BLOB data type?
Does the custom context formatter support this data type ... that is to
say does the BLOB work with Hashtable rawContent variable?
How would you access/retrieve this data from the rawContent variable?