Does kentico have an issue with Russian characters?

Vic Carter asked on January 23, 2015 21:57

I am using a query to populate a repeater on a site localized for Russia. The query matches the nodeAlias of my document to populate a details page. This works just fine for English, but will not return results for a Russian page. If I create a view and run the same query, same result. Is there a setting that would cause this to happen.

Thank You.

localization

Correct Answer

Vic Carter answered on February 17, 2015 16:33

The solution was simpler than that. The issue was in how the NodeAlias value was being recognized in the query.

NodeAlias = N'{% QueryString.GetValue("NewsItem") |(identity)GlobalAdministrator%}'

Adding the N before the parameter allowed the database to recognize the characters correctly.

Thank you for your response.

0 votesVote for this answer Unmark Correct answer

Recent Answers

Filip Ligač answered on January 26, 2015 16:07 (last edited on February 1, 2015 12:18)

Hello Vic,

Could you please specify which version of Kentico you are using? I remember there was a problem in versions 6 and 7 where some of the characters in the page alias were overwritten with characters without diacritics when using e.g. Azbuka or Japanese alphabet.

If that is the case, there are basically 2 possible solutions:

1. Utilize OnBeforeRemoveDiacritics event to handle the character rewriting. More details about this can be found in Developer's Guide - Custom handling of URL path values.

2. Upgrade to Kentico 8 where the problem no longer occurs.

Would one of the options work for you?

0 votesVote for this answer Mark as a Correct answer

Vic Carter answered on January 26, 2015 16:14

We are on version 7. My main concern is that this is happening within the database. Even if I manually type the nodeAlias into a custom view, I get no results. If I copy the node alias directly from another view, results generated in sitemanager, and paste that into my query. No match. Not really sure how to debug this.

0 votesVote for this answer Mark as a Correct answer

Vic Carter answered on January 26, 2015 18:00

As a follow up I noticed that our clients system admin has not added the Russian localization pack into the UI Cultures. Is it safe to assume this may be part of the problem?

0 votesVote for this answer Mark as a Correct answer

Filip Ligač answered on February 17, 2015 16:03

Hello Vic,

Have you had a chance to try to handle the characters as it was described in the link I sent in my previous message? I believe it should work in your case and ensure you can retrieve the pages using their NodeAlias from custom views.

Best regards,

Filip

0 votesVote for this answer Mark as a Correct answer