MAMP, sql encoding, cyrrilic & something wrong

Hello, after the site was hacked (it was on Joomla 1.5). I decided to change it and use Joomla 3 as a base platform.
I have installed quickstart of JA Universety, updated all components, made changes to template.css (minor: colors and images). All work fine. After that I add Ukrainian language to content. Native name of hte language had not been saved correctly -- only ???????? symbols. The smae situation repeated with new menu items.

After googling I have find out that there is some problems with encoding latin1_swedish_ci
I have provided conversion of all tables to utf8_general_ci with the next command:

Code:

CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;

Cyrillic symbols started to work properly, but SlideShow Module< MEga Menu stopped to work.
The new clear installation resulted to the same situation.

What kind of encoding i have to choose for sql base and at server to have normal cyrillic usage

Thank you

1 answer

This question is now closed

Written By

Comments