How to stop Yii framework trimming string before saving to DB
I have an unfortunate requirement which, despite my gasps of disgust and protest, have to be enforced.
I have to store a string in the database (sqlserver) untrimmed. (Yes I know, very bad!)
Unfortunately it is data from another system. The preceding whitespace is not a consistent length nor is there any way for me to calculate the number of spaces before 开发者_如何学Cthe string.
This means I have to store the string with the preceding whitespace (sic)
So the question is, How can I prevent the Yii framework trimming the string automatically.
Thanks in advance.
Example code:
$mod = MyModel::model()->findByPk(1);
$mod->string = ' My String'; // <- Yii please don't trim the preceding whitespace.
$mod->save(); // <- Yii automatically trims the string NO DON'T DO IT
While I can think of a few rather complicated work-arounds, the easiest method may be to simply urlencode or otherwise tokenize the whitespace -- the main down-side is you have to make sure any retrieval method decodes it properly.
精彩评论