Cyrillic character problem

This is a place to discuss how to adapt mojoPortal to the needs of different cultures. Before asking questions here please first review the localization documentation.

This thread is closed to new posts. You must sign in to post in the forums.
11/17/2009 2:35:29 AM
Gravatar
Total Posts 18

Cyrillic character problem

It's very nice CMS.

And i using mysql and problem is that i can't put content my language (Mongolian). After putting the contents.

It's shows me "??????" .(Menus and pages)

Is it depends on collation on mysql .

Any idea?

11/17/2009 7:20:48 AM
Gravatar
Total Posts 18439

Re: Cyrillic character problem

Yes, you need to use utf8 for the charset and you need to use utf8_unicode_ci for the collation when you create the database so that all tables are created with the same charset and collation.

Hope it helps,

Joe

11/17/2009 7:25:03 PM
Gravatar
Total Posts 18

Re: Cyrillic character problem

Thanks for reply .

I tried as you suggest but it's same.

Even i tried put Cyrillic (Mongolian) directly to the table(Not using application directly to the table.) 

then it shows me correct one.

I think problem is that when application putting information to the table it occurs.(Datalayer)

 

11/17/2009 7:33:19 PM
Gravatar
Total Posts 18439

Re: Cyrillic character problem

Hi,

This site is using MySql, please try typing some Cyrillic text here in the forums and see if it works or not.

Best,

Joe

11/17/2009 7:34:55 PM
Gravatar
Total Posts 18

Re: Cyrillic character problem

Here is some texts using XP unicode."Ххрыбхөыро хйоыбөрх йлоыблөойрхөолрйыхбөойрхылбөойхылбоөхйбхйбхөйлыро"

11/17/2009 7:35:32 PM
Gravatar
Total Posts 18

Re: Cyrillic character problem

Yes mysql it's works on Forum.

11/17/2009 7:40:18 PM
Gravatar
Total Posts 18439

Re: Cyrillic character problem

I checked my database and it is using utf8_general_ci for the collation, so it was probably incorrect when I told you to use utf8_unicode_ci

Hope it helps,

Joe

11/17/2009 7:55:31 PM
Gravatar
Total Posts 18

Re: Cyrillic character problem

nope now all of my tables collation utf8_general_ci but not working.

Even i tired to create forum on my site and tried but not works.

i'm hosting it on my localhost IIS and local mysql.

Is there any specific configuration there?

11/17/2009 8:00:05 PM
Gravatar
Total Posts 18439

Re: Cyrillic character problem

Hi,

nope now all of my tables collation utf8_general_ci

Are you 100% sure of that? Have you inspected the collation on specific table columns? Column collation could be different than table collation.

The only thing I know is when I installed MySql I set utf8 and collation at install time and it is the default for the installation. Maybe making it the default just for a database is not enough if the installation has different settings as the default.

Hope it helps,

Joe

11/17/2009 8:08:51 PM
Gravatar
Total Posts 18

Re: Cyrillic character problem

Thanks for quick reply

Yes i'm sure.

now my database collation and table collation are same.(utf8_general_ci)

If you want i'll show you via screenshot of my settings

 

11/17/2009 8:23:08 PM
Gravatar
Total Posts 18439

Re: Cyrillic character problem

Do you have this as part of your connection string?

Charset=utf8;

Hope it helps,

Joe

11/17/2009 8:30:44 PM
Gravatar
Total Posts 18

Re: Cyrillic character problem

There is 2 connection string one is in Web.config another one is in user.config.

in  web.config there is Charset=utf8; in user.config no charset.

I'll try add charset in user.config

11/17/2009 8:33:49 PM
Gravatar
Total Posts 18439

Re: Cyrillic character problem

That will most likely fix it. After you edit user.config make sure to touch (type a space and save it) web.config so it reloads the settings.

Best,

Joe

11/17/2009 8:46:35 PM
Gravatar
Total Posts 18

Re: Cyrillic character problem

Thanks a lot.

It works man.

Problem was in userconfig.

Thanks a million.

11/18/2009 11:38:35 AM
Gravatar
Total Posts 18439

Re: Cyrillic character problem

Hi,

I see, I did not include that part in the sample MySqlConnectionString in user.config. I will fix that now so it wil be more obvious in future releases.

Best,

Joe

11/18/2009 11:16:46 PM
Gravatar
Total Posts 18

Re: Cyrillic character problem

thanks again for your help

and lovely CMS.

You must sign in to post in the forums. This thread is closed to new posts.