Form Update Problem With Spaces

Yii 1.1 General Discussion
1

Hi,

I have a problem with MSSQL, when I try to modify a column, the text field is automatically full with spaces, so I have to delete all the spaces to be able to make the update.

Someone know how to deal with this spaces generated by sql server or yii ?

Thanks for help.

EDIT:

Problem solved, I used nchar instead of nvarchar

2

Also, I always use make a trim filter as a first rule in my models’ rules() method.

3

Hi

what is the type of column in your sql ?

varchar or char ?