I get code from http://doc.silverstripe.org/framework/en/tutorials/5-dataobject-relationship-management
If I use Cyrillic in the title Project page.
Then on Project tab I can't find Project by Page Name and Link it.
I can't create Many-many relationships: Mentor with cyrillic Project
Pages in Latin are no problems.
We've moved the forum!
Please use forum.silverstripe.org for any new questions
(announcement).
The forum archive will stick around, but will be read only.
You can also use our Slack channel
or StackOverflow to ask for help.
Check out our community overview for more options to contribute.
If I use "Add Mentor"
in mysql.log i have next :
Working example for Latin characters
5002 Query SELECT DISTINCT "Mentor"."ClassName", "Mentor"."Created", "Mentor"."LastEdited", "Mentor"."Name", "Mentor"."ID", CASE WHEN "Mentor"."ClassName" IS NOT NULL THEN "Mentor"."ClassName" ELSE 'Mentor' END AS "RecordClassName" FROM "Mentor" WHERE ("Name" LIKE 'tes%') AND ("Mentor"."ID" NOT IN (SELECT DISTINCT "Mentor"."ID" FROM "Mentor" INNER JOIN "Project_Mentors" ON "Project_Mentors"."MentorID" = "Mentor"."ID" WHERE ("Project_Mentors"."ProjectID" = '9'))) ORDER BY "Mentor"."Name" ASC LIMIT 20
Not a working example for the Cyrillic: in admin area I input 'Йод', but mysql try find LIKE '%u0419%u043E%u0434%'
5025 Query SELECT DISTINCT "Mentor"."ClassName", "Mentor"."Created", "Mentor"."LastEdited", "Mentor"."Name", "Mentor"."ID", CASE WHEN "Mentor"."ClassName" IS NOT NULL THEN "Mentor"."ClassName" ELSE 'Mentor' END AS "RecordClassName" FROM "Mentor" WHERE ("Name" LIKE '%u0419%u043E%u0434%') AND ("Mentor"."ID" NOT IN (SELECT DISTINCT "Mentor"."ID" FROM "Mentor" INNER JOIN "Project_Mentors" ON "Project_Mentors"."MentorID" = "Mentor"."ID" WHERE ("Project_Mentors"."ProjectID" = '9'))) ORDER BY "Mentor"."Name" ASC LIMIT 20
Why mysql wrong gets my Cyrillic characters?