Hi I noticed that if I dont use anything just $data->column I get same result as you did with decode. What is the benefit of using decode? Is there some security benefit in using decode since if I get same result without it why call it at all? Anyone who can explain.
You might want to take a look at CHtmlPurifier, it can process your output and you won’t need to CHtml::encode() on the content. This is what I use in my applications.
Does the stored HTML need to be really complicated ? If not, maybe nicer solution would be to store markdown formatted text and use CMarkdown for rendering. Storing html could lead to security issue. Anyway, best is to use a "text" data type instead of a a blob.