21282 Posts in 5730 Topics by 2601 members
General Questions
SilverStripe Forums » General Questions » Many-many relationships: Mentor with cyrillic Project
General questions about getting started with SilverStripe that don't fit in any of the categories above.
Moderators: martimiz, Howard, Sean, Ryan M., biapar, Willr, Ingo, swaiba, simon_w
|
Page:
1
|
Go to End | |
| Author | Topic: | 174 Views |
-
Many-many relationships: Mentor with cyrillic Project
10 November 2012 at 4:43am Last edited: 10 November 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.
-
Re: Many-many relationships: Mentor with cyrillic Project
13 November 2012 at 3:57am
If I use "Add Mentor"
in mysql.log i have next :
Working example for Latin characters5002 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?
| 174 Views | ||
|
Page:
1
|
Go to Top |
