after connecting with a mysql client use
set names utf8;
select * from node limit 6; //now you will see any titles that are in UTF8
set names utf8;
select node.nid,node_counter.nid,node.title,node_counter.totalcount from john_physics.node left join john_physics.node_counter on node.nid = node_counter.nid;
BELOW IS NO LONGER NECESSARY IN DRUPAL 7
download and enable i18n module for international translated content and menus Administer -> Site Building -> Modules -> List (then the checkbox)
Administer -> Site configuration -> Languages = * Add language If you edit the langauge (e.g. bulgarian) you'll see a path prefix 'bg'
Administer -> Site configuration -> Languages -> List -> *Configure Path prefix with user language setting fallback
Administer -> Site configuration -> Languages -> List -> * Multilingual system Content selection mode: Current language and language neutral.
Hide content translation links: switching language will only be available from the language switcher block.
(I prefer to leave the interface language in English for more universal technical accessibility).
Ensure that Content Types are configured to use MultiLanguage settings:
Administer -> Content management -> Page = * Edit
Workflow = Enabled with translation ... SAVE Edit again and now you can ensure Content Types have "Multilanguage" enabled
Under "Workflow settings" select Multilingual support - Enabled, with translation. This will add a "Translate" tab to the content page.
Now when you Create Content there will be a LANGUAGE dropdown!
When editing Content, if the "Translate" tab is not available for your content then the language for the content is probably set to "Language neutral".
After you set it to "English" then SAVE, then EDIT again, the TRANSLATE tab will appear. One way to avoid this is to force new content to have a language from the Content Types...
Translate -> Add Translation Type in your translation of the page.
Add the language switcher to the left sidebar (above may look ugly)
Administer -> Site building -> Blocks
Troubleshooting - sometimes it can help to deactivate and reactive menu items that might not appear/disappear correctly. (And flush all caches?)
http://domain.com/admin/build/menu-customize/primary-links
To clean up links you have to modify/edit each one?
Thus if you're in the Bulgarian language, only menu items that link to Bulgarian pages will appear.
TROUBLESHOOTING PAGE NOT FOUND If the user starts with a "foreign language" and then uses the language switcher block the "English" pages may appear as "page not found"...
http://domain.com/content/login
You have to modify the language prefix for English to be "en" so that the language switcher/in8 works properly...
http:/domain.com/en/content/login
download and enable translation management module http://drupal.org/project/translation_management Administer -> Site Building -> Modules -> List (then the checkbox)
Administer -> Content management -> Translation Management *Status - shows you any configuration that you might have overlooked
e.g. Status Check = Multilingual support
Page Content type Page has multilingual support enabled Story Content type Story has multilingual support enabled
i18n status = This section details status for i18n modules. i18n Taxonomy i18ntaxonomy module enabled i18n Blocks i18nblocks module enabled
If I had an error it would give me a link to change the configuration: Administer -> Content management -> Page http://domain.net/en/admin/content/node-type/page
Content Translation = all checked! (Synchronization = all checked!)
TRANSLATION DASHBOARD List of content that might need translation
Nice option for "Translators" (e.g. machine = google translate) Manage Translators allows you to Add your own Drupal Users (permissions) (or you could hire their professionals?)
STRING TRANSLATION Items are automatically translated (sometimes with hilarious results) based on "matches" ...
You could import a .po (translation of strings) or you can manually do a string by string translation (which Drupal will replace on public pages as necessary)
Administer -> Site building -> Translate interface The overview of "string" based translations
http://drupal-translation.com/content/adding-menu
Excellent tutorial with screenshots http://drupal-translation.com/content/creating-translations