Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

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.

General Questions /

General questions about getting started with SilverStripe that don't fit in any of the categories above.

Moderators: martimiz, Sean, Ed, biapar, Willr, Ingo, swaiba

Many-many relationships: Mentor with cyrillic Project


Go to End


2 Posts   836 Views

Avatar
WebSpilka

Community Member, 89 Posts

10 November 2012 at 4:43am

Edited: 10/11/2012 4:44am

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.

Avatar
WebSpilka

Community Member, 89 Posts

13 November 2012 at 3:57am

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?