Hi,

regarding mentioned , please note i am using Arabic collation for my sql server database .

after running the survey , i was unable to view responses .. no error message received but there was 0 records.

i have checked the issue and found out that token column in tokens table uses SQL_Latin1_General_CP1_CI_AS collation while token column in responses table uses Arabic_CI_AS_WS collation which result in collation conflict .

to solve the issue i changed the collation used while creating the token table.

this done in application\models\Token.php as per below

///////////
public static function createTable($surveyId, array $extraFields = array())
{
$surveyId=intval($surveyId);
// Specify case sensitive collations for the token
$sCollation='';
if (Yii::app()->db->driverName=='mysqli' | Yii::app()->db->driverName=='mysqli'){
$sCollation="COLLATE 'utf8_bin'";
}
if (Yii::app()->db->driverName=='sqlsrv' | Yii::app()->db->driverName=='dblib' | Yii::app()->db->driverName=='mssql'){
$sCollation="COLLATE Arabic_CI_AS_WS";
}
/////////////

kindly advise on that matter .....