XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Community Support forums / 
  3. XOOPS general usage questions 
  4.  / Multilanguage
Register
11
ghia
Re: Multilanguage

  • 2010/5/21 9:04

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


When non alphanumeric characters as Arabic turn into ???, this means in general that you database collation and character set specifications in /mainfile.php and /language/yoursiteslanguage/global.php don't match.
Examples are:
latin1_swedish_ci, latin1 and ISO-8859-15
and
utf8_unicode_ci, utf and UTF-8
Make sure never to mix up latin - ISO and utf.

In XLanguage you have also character settings in the setup for the languages. These should match the XOOPS settings.
Which settings do you have?
12
Mechs
Re: Multilanguage

  • 2010/5/21 11:37

  • Mechs

  • Just popping in

  • Posts: 35

  • Since: 2007/4/16


Hi ghia,

In my database from phpMyadmin,
MySQL connection collation: utf8_general_ci

Server: Localhost via UNIX socket
Server version: 5.0.89-community
Protocol version: 10
User: xxxxxxxxxxxxxx
MySQL charset: UTF-8 Unicode (utf8)
MySQL client version: 5.0.89

In mainfile.php:
if (defined("XOOPS_DB_CHARSET")) die('Restricted Access');
define('XOOPS_DB_CHARSET', 'utf8');

In global.php:
define('_CHARSET', 'UTF-8');
define('_LANGCODE', 'en');

What should i change here.
13
ghia
Re: Multilanguage

  • 2010/5/21 12:10

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


These settings are correct.
You use english as language (general preferences) for your site?

What are the settings in xlanguage?
14
Mechs
Re: Multilanguage

  • 2010/5/21 12:21

  • Mechs

  • Just popping in

  • Posts: 35

  • Since: 2007/4/16


@ghia,

I did not use xlanguage.

The language i use is english

I'd tried changing the code below in global.php to

define('_CHARSET', 'ISO-8859-1');

and did not change anything else, now it works, funny

anyway thanks ghia, really apreciate your reply, there is some other problem need your answer on my other site, will post the question later.
« 1 (2)

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

322 user(s) are online (295 user(s) are browsing Support Forums)

Members: 0

Guests: 322

more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Nov 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits