|
|
v5: https://github.com/LimeSurvey/LimeSurvey/pull/3311 |
|
|
|
Have to apply to : Token + Theme + etc … : need new issue reported
- I reopen an issue with MSSQL :)
|
|
|
|
Have to apply to : Token + Theme + etc … : need new issue reported
Token seems OK.
Still, from a code search these models pop up:
- Assessment.php
- Box.php
- FailedEmail.php
- Notification.php
- Participant.php
- ParticipantAttributeName.php
- ParticipantShare.php
- Permissiontemplates.php
- Question.php
- QuestionGroup.php
- QuestionTheme.php
- SavedControl.php
- SettingsUser.php
- SurveyDynamic.php
- SurveyLink.php
- Surveymenu.php
- SurveymenuEntries.php
- SurveysGroups.php
- SurveysGroupsettings.php
- SurveyURLParameter.php
- Template.php
- TemplateConfiguration.php
- User.php
- UserInPermissionrole.php
BTW: On mysql case insensitve works fine due to the collation (ex: utf8_general_ci), right? |
|
|
|
BTW: On mysql case insensitve works fine due to the collation (ex: utf8_general_ci), right?
It's about escaping https://github.com/yiisoft/yii/issues/4512
For the other: mus check real utility :) |
|
|
|
BTW: On mysql case insensitve works fine due to the collation (ex: utf8_general_ci), right?
It's about escaping https://github.com/yiisoft/yii/issues/4512
Got lost. What is about escaping?
What I meant was that the LSDBCriteria implements case insensitive for pgsql.
Then I was asking, why mysql is out of that? I am assuming because of the collation being used when creating the DB?
For the other: mus check real utility :)
I would just do a replacement on those files on DEV branch.
Have them all the same. |
|
|
|
Got lost. What is about escaping?
Sorry : MSSQL here (not MySQL) else it's about compare function (with escaping ) public function compare($column, $value, $partialMatch = false, $operator = 'AND', $escape = true)
NOT RELATED TO THIS ISSUE. Just same file partial task are alrea |
|
|
|
What I mean about mysql is,
- LSDBCriteria adds insensitive comparison for pgsql
- So, when a search is being done on MySQL is case sensitive or insensitive?
- I believe is case insensitive, not because of Yii, justbecause the collation used is utf8mb4_unicode_ci
Initially it was a question. But now I have already answered myself :) |
|
|
|
I believe is case insensitive, not because of Yii, justbecause the collation used is utf8mb4_unicode_ci
Yes,
Initially it was a question. But now I have already answered myself :)
I din't understand it was a question … sorry. |
|
|
|
Tested ok on mysql
Do you have a pgsql for testing there as well? |
|
|
|
Master PR: https://github.com/LimeSurvey/LimeSurvey/pull/3339 |
|
|
|
Master PR test ok on mysql
Do you have a pgsql for testing there as well? |
|
|
|
I tested both successfully with Postgres database as well. |
|
|
|
Fix committed to 5.x branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=35331 |
|
|
|
Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=35333 |
|
|
|
Fixed in Release 6.2.2+230814 |
|
