mssql connector, case sensitive issue when trying to login

yiisus · February 26, 2012, 6:08am

Hi,

This is how I’m connecting to the Db.

  'connectionString' =&gt; 'sqlsrv:server=(local);Database=IMDB',

I was able to communicate with the DB and create a user Model and CRUD

However when changing to use the user table to authenticate (instructions from: http://www.yiiframework.com/wiki/80/add-information-to-yii-app-user-by-extending-cwebuser-better-version/)

When I try to login, yii gets the record of the user with case sensitive field names and yii active record and

db\schema\CDbCommandBuilder.php try to access the fields with lowercase.

Any suggestions ?

Thanks in advance.

yiisus · February 26, 2012, 7:14am

yiisus:

Hi,

This is how I’m connecting to the Db.
  'connectionString' =&gt; 'sqlsrv:server=(local);Database=IMDB',
I was able to communicate with the DB and create a user Model and CRUD

However when changing to use the user table to authenticate (instructions from: http://www.yiiframework.com/wiki/80/add-information-to-yii-app-user-by-extending-cwebuser-better-version/)

When I try to login, yii gets the record of the user with case sensitive field names and yii active record and

db\schema\CDbCommandBuilder.php try to access the fields with lowercase.

I just changed my class UserIdentity class to use the right case for the login and password fields.

But I guess that I’m going to continue referring to the fields using the proper case as they are defined in the mssql database. I wish I could find a way to disable the cases sensitive field names.