Database Collation problem

General questions regarding the use of languages in Joomla! 1.5.

Moderator: General Support Moderators

Joomla! Fledgling
Joomla! Fledgling
Posts: 3
Joined: Fri Oct 12, 2012 8:08 am

Database Collation problem

Post by richfever » Fri Oct 12, 2012 8:18 am


Our website was running fine with English and other European languages. However, when we want to add more language, including Chinese, the article manager turn all Chinese content into ???.

We know that the mysql db collation set was set to "latin-swedish_ci", so we change it to "utf8_general_ci" with some PHP script and confirmed the db collation was updated when we checked at the mysql command line. However, when we try to work on Joomla again, the problem remains and the system info still telling the db collation was in "latin_swedish_ci". What have I missed? I've been trying for days but no success. Can anyone help? Thanks.


User avatar
Joomla! Master
Joomla! Master
Posts: 27488
Joined: Wed Aug 13, 2008 2:57 am
Location: Chennai, India

Re: Database Collation problem

Post by imanickam » Fri Oct 12, 2012 8:36 am

Suggest reviewing the collation sequence of tables and the columns.
Ilagnayeru (MIG) Manickam | இளஞாயிறு மாணிக்கம்
Joomla! - Global Moderators Team | Translations Coordination Team | Tamil (தமிழ்) Translation Team

Eegan - Support the poor and underprivileged

I've been banned!
Posts: 16
Joined: Wed Apr 10, 2013 10:47 am

Re: Database Collation problem

Post by lolol » Mon Jun 24, 2013 3:40 pm

Im getting different collation in different objects in a database...

Collation of Tables is 'SQL_SwedishStd_Pref_CP1_CI_AS'
Collation of Stored Procedure is 'SQL_Latin1_General_CP1_CI_AS'
Which is creating problem while executing query. Can someone help me out?

Thanks In Advance



Return to “Language - Joomla! 1.5”